BCU Sr. Data Warehouse Developer – BAXTER – Vernon Hills, IL

As an employer, BCU models the dynamic assets of a top workplace, including confidence in company leadership, competitive compensation and benefits, employee development, workplace flexibility, and a passionate employee culture supporting a unified vision.

At BCU, you’ll have a career in a growing organization and an environment that supports your professional and personal growth. For these reasons, BCU has been chosen as a Chicago Tribune Top 100 Workplace and a certified Great Place to Work.

Visit the link below to learn more about #LifeAtBCU:

https://players.brightcove.net/3101254895001/default_default/index.html?videoId=6013229634001

Accountable for the quality and delivery of ETL, data warehouse and BI solutions, within prescribed resource limits, and in accordance with client requirements and departmental standards. Provide leadership by assisting clients in identifying and responding to opportunities for cost-effective automation. This individual will develop end-to-end solutions utilizing Microsoft SQL Server software to ensure the long-term reliability, scalability and maintainability for an enterprise data warehouse.

• Research and implement new, relevant SQL technologies and SQL development-supporting applications
• Collaborate heavily with business analysts, business owners, members of the BI team and DBA to ensure the creation of production-quality designs and implementations
• Manage multiple tasks and changing business requirements
• Enforce standards, design styles and best practices
• Perform full Data Warehouse life-cycle systems development
• Design BI ETL strategies and solutions using MS SQL Server SSIS Strong experience and understanding of MS SQL Server SSRS/SSAS
• Create and manage database objects including tables, indexes, procedures, cubes, etc.
• Create MDX and SQL scripts as required for use in MS SQL Server Migrate, maintain and enhance ETL processes
• Analyze source data of different types and design programs for data integration, cleansing and transformations
• Develop BI dashboards using Microsoft Excel

Requirements:

• Ability to thrive in a fast-paced environment with multiple ongoing projects concurrently
• Requires four-year college degree in computer science or similar concentration or business management with a focus in technology.
• Strong written, verbal, team and customer service skills.
• 7+ years experience developing BI ETL solutions.
• 7+ years experience with MS SQL Server applications including analysis, design, development, configuration, customization, validation and deployment.
• Strong experience with Kimball Dimensional Modeling.
• Strong MDX skills.
• Strong SQL tuning skills.
• Strong analytical, data validation and problem-solving skills.
• Strong knowledge of Data Warehousing and Business Intelligence reporting tools

Experience with the following is a plus:

• Azure SQL
• Azure Data Factory
• Azure Synapse
• Redgate SQL Version Control
• General knowledge of the financial industry and specific knowledge of the credit union industry.
• DocXpress

BCU Shared Values. We act with INTEGRITY. We follow the golden rule without exception. We display COURAGE in our convictions. We drive innovation, reaching beyond boundaries and thoughtfully explore new horizons. We excel through COLLABORATION. By working as one, sharing information and seeking solutions, we deliver exceptional outcomes. We WOW our Members. We focus intensely on putting the member first, delivering extraordinary experiences that create lasting relationships inside and outside the organization.

Life at BCU. With a culture built off relationships and referrals, we’re committed to creating the best work environment possible. From our casual dress code to flexible work arrangements, we’ve created a unique culture that supports a healthy work/life balance. For this reason and more, BCU has been chosen as a Chicago Tribune Top 100 Workplace. #LifeAtBCU

Equal Employment Opportunity
Baxter is an equal opportunity employer. Baxter evaluates qualified applicants without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability/handicap status or any other legally protected characteristic.

EEO is the Law
EEO is the law – Poster Supplement

Pay Transparency Policy

Reasonable Accommodations
Baxter is committed to working with and providing reasonable accommodations to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application or interview process, please send an e-mail to [email protected] and let us know the nature of your request along with your contact information.