Data Warehouse Developer

$100,200 - $150,200/Yr

Navigant Consulting - Chicago, IL

Full-time - Mid Level

Chicago, IL

Professional, Scientific, and Technical Services

About the position

As an experienced Data Warehouse Developer at Guidehouse, you will join a collaborative IT data warehouse team focused on integrating and analyzing data to meet business reporting needs. Your role will involve developing data flows, building data models, and maintaining the corporate data warehouse and data lake using Microsoft technology stacks. You will also perform complex data queries and business analysis, particularly in financial data, while translating internal needs into technical requirements.

Responsibilities

• Develop, test, and maintain relational and multidimensional OLAP models.
• Participate in the development and maintenance of the corporate data warehouse and data lake.
• Analyze data and develop data flows using Microsoft technology stacks.
• Perform complex data queries and business data analysis, including financial data.
• Translate internal needs into technical requirements.

Requirements

• Requires a University Degree and minimum 4 years of prior relevant experience OR 8 years of relevant experience in lieu of degree.
• 4+ years of relevant professional experience as a Data Warehouse developer or engineer using Microsoft technologies.
• Ability to obtain a National Security Clearance or a U.S. Federal Government Public Trust.
• Experience developing SQL relational databases and optimizing complex queries.
• Experience developing semantic data models.
• Experience analyzing and modeling financial/ERP data.
• Excellent analytical and problem-solving skills.
• Good written and verbal communication skills.
• Ability to work independently as well as collaborate within a team environment.

Nice-to-haves

• B.S./B.A. in Computer Science, Information Systems, or similar computational discipline.
• Experience developing Azure Analysis Services tabular models.
• Experience with Power BI Premium advanced data modeling.
• Experience creating Power BI reports.
• Experience with source code version control technologies such as Git and Azure DevOps.
• Well versed with data structures and algorithms.
• Understanding of the software development lifecycle.
• Experience interacting with end-users to understand and document business and functional requirements.

Benefits

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Discretionary variable incentive bonus eligibility
• Parental Leave and Adoption Assistance
• 401(k) Retirement Plan
• Basic Life & Supplemental Life
• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
• Short-Term & Long-Term Disability
• Student Loan PayDown
• Tuition Reimbursement, Personal Development & Learning Opportunities
• Skills Development & Certifications
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Emergency Back-Up Childcare Program
• Mobility Stipend