Manager of Data Warehousing

Location:

United States, Michigan

Location:

United States, Ohio

Location:

United States, Illinois

Location:

United States, Colorado

Make your mark.

Plante Moran's technology services team has been awarded

Insider Pro

and

Computerworld's "100 Best Places to Work in IT"

for five consecutive years.

We are also previous recipients of the

InformationWeek IT Excellence

award and the

CIO 100

award. If you're seeking professional growth, like being innovative and challenged, and have a desire to work on impactful business technology solutions, we want to hear from you!
What does diversity, equity, and inclusion mean to Plante Moran? It means that all staff members have equitable and fair opportunities to succeed, in an inclusive environment, with their individual, unique identities.
This opportunity provides the option of working 100% remotely. At the core of Plante Moran's culture is an understanding that the whole person comes to work, and we want to meet you where you are. That's why we offer various alternative work arrangements to support staff and their evolving needs throughout their career.
Your role.
We are looking for a Manager of Data Warehouse and Semantic Model Development to be a senior leader on the Data Services team which includes all data warehouse, semantics model and visualizations, database operations, and data science capabilities. This role will be the leader of our Data Warehouse and Semantic Model development teams.

Your work will include, but not be limited to:
Manage daily operation and expansion of the Data warehouse and semantic model.
Lead a team of DW engineers and Azure Analysis Services developers in the creation and operations of a multi-tier data warehouse/Semantic models
Develop DW and Azure Analysis Services solutions to address current and future information system needs, and create process improvements and controls for defined solutions
Work with data SME's and data architects to create end user friendly data models to support self service and data science use cases.
Works closely with customers and colleagues to identify opportunities to utilize information systems to improve business processes, promote the strategic use of information while enabling seamless access to information.
Interacts with the staff to produce data mapping and requirements, deliver high quality solutions utilizing Microsoft BI tools.
Provides prototyping solutions, prepares test scripts, and conducts tests and for data replication, extraction, loading, cleansing, and data modeling.
Possesses working knowledge of Relational Database Management Systems (DBMS) and data warehouse front-end tools.
Be proficient in creating and maintain SQL data structures and store procedures.
Works closely with the technical and business team lead to drive solution options analysis, development and implementation of BI solutions.
Contributing team member to the design and support of data architecture, database design and integration, transformations, and load processes.

The qualifications.
7+ years managing the operations and building Data

Warehouses on an Azure SQL platform including project management, resource

assignment, architectural design.
2+ years managing and developing in Azure Analysis

Services or SSAS
3-5 years' experience using the Microsoft Azure Data integration tools including SSIS/IR, ADF and ADO
Have direct responsibility for leading a team of

developers to design and build BI solutions for Power BI or other

reporting tools.
At least 3 + years of team leadership experience in Data

Warehouse/BI data environment
Extensive experience creating data models and

translating into a DW design and Analysis Services model to support

analytical requirements.
Experience managing all technical aspects of a

production DW: monitoring, error handling, data quality validation and

support.
Extensive experience with Azure SQL Databases: Stored

Procedures, Views and T-SQL.
Problem Solver - Interested in finding solutions

to/supporting existing solutions, as well as, continuing to advance

through new development
Experience with Azure DevOps, ADF Experience (Running

SSIS from ADF and native ADF pipelines)
Analytical approach to problem-solving; ability to use

technology to solve business problems
Passionate about learning new technologies
Familiarity with database-centric applications
Strong verbal and written communication skills; strong

time-management and organizational skills
Proven ability to build out, enhance, and maintain the

company data environment, including modifications and maintenance of

various ETLs, transactional data sets, and company data assets.
Manage data access, data quality, and data delivery

tasks within the framework of specific client BI and IT projects.
Ability to work assigned projects and trouble tickets,

delivering results within promised timeframes.
Ability to validate & ensure production level

functionality/style is thoroughly tested, and the code reflects the

current standards.
Our difference.
We are a nationally recognized public accounting, consulting, and wealth management firm, consistently ranked as one of FORTUNE magazine's "100 Best Companies to Work For." At Plante Moran, we live by the Golden Rule, fostering a relatively "jerk-free" culture with the lowest staff turnover rate in the industry. Our supportive network of well-rounded professionals is excited to catapult your growth and help pave your pathway to professional excellence.
Apply now. Make your mark.
This is an exempt position, so you may have to work hours that exceed the standard 40-hour work week.
Plante Moran is committed to a diverse workplace.We strive to create a culture where each person feels accepted and valued. We believe that each person's ultimate potential begins with first acknowledging their inherent dignity. When we can recognize - and celebrate - our many human differences, we're able to create a workplace where all staff feel a sense of belonging and an opportunity to succeed. This allows us to attract and retain the best talent, serve clients through diverse thinking, and better represent and support the various communities in which we live and work. Plante Moran is an Equal Opportunity Employer.
Plante Moran maintains a drug-free workplace.
Interested applicants must submit their resume for consideration using our applicant tracking system. Due to the high volume of applications received, only candidates selected for interviews will be contacted. Candidates must be legally authorized to work in the United States without sponsorship, with the exception of candidates that are bilingual in Japanese and English. Unsolicited resumes from search firms or employment agencies, or similar, will not be paid a fee and become the property of Plante Moran.
The specific statements above are not intended to be all-inclusive.
#LI-LS2
#LI-Remote

Salary Class

Salary

Colorado Equal Pay for Equal Work Act (SB 19-085) Information

Compensation is commensurate with technical skills and experience and is provided in accordance with the CO Equal Pay for Equal Work Act.

Compensation information posted is based on a position being located in the state of CO.

Please review position location for applicable geographic location.

Colorado monthly base range is as follows:

$10,500.00 to $15,708.33

We are pleased to offer eligible staff a robust benefits package. Eligibility and contribution requirements for some of these benefits vary based on the number of hours staff work per week. Highlights include health, dental, vision, disability and life insurance. These standard offerings are effective on the first of the month following your start date. In addition to this, eligible staff are able to take advantage of our Flexible Time Off and various pre-determined holidays as well as a balance fund, 401(k) plan, flexible benefits plans, business-related travel expense, lodging and meal reimbursement for business-related use. A Pension plan is also available for eligible administrative and paraprofessional staff. A discretionary bonus plan is available for eligible staff. Plante Moran also offers Interns and Contractors the option to elect health insurance under our contingent staff medical plan as of the 1st of the month following 60 days of employment in addition to limited paid time sick time. Seasonal staff are not eligible for benefits.

Colorado Job Application Fairness Act

Under Colorado's Job Application Fairness Act, you have the right to redact from any documents that you submit in connection with your application information that identifies your age, date of birth, or dates of attendance at or graduation from an educational institution. Should you wish to exercise your right to redact such information, please redact it prior to submitting the documentation.

#J-18808-Ljbffr