American Heart Association ETL Developer in Chicago, Illinois
Are you ready to join an organization where you can be a relentless force for a world of longer, healthier lives?
Envision all Americans enjoying ideal cardiovascular health free of heart disease and stroke. At the American Heart Association and American Stroke Association, we get to work toward that goal every single day. Is it easy? No. Is it worthwhile? you bet!
This is satisfying work that makes a real difference in people's lives. You can achieve professional growth with personal fulfillment. You will connect with people and make a lifesaving impact. You will partner with individuals, schools, lawmakers, healthcare providers and others to ensure everyone has access to healthier lifestyle choices and proper healthcare.
The American Heart Association (AHA) has an excellent opportunity for an ETL Developer in our National Center. Location of selected candidate is flexible as long as location allows for cost-effective and efficient travel.
In this role, you will be responsible for delivering the vision of the department through process and development. Additional responsibilities include developing and delivering data warehouse infrastructure and integration in collaboration with architects, analysts and team members while working in an Agile environment.
*Due to the current pandemic, all staff are currently working from home. In the future, this position will resume being based in the local office*
Essential Job Duties:
Develops ETL within the department standards for achieving maximum performance, compliance and efficiency of the Data Warehouse and MDM ecosystem. By providing adhering to the Principal guideline documents, Architecture Models, ETL Flow Models and Data Models set forth by management and BI Solutions Architects.
Ensure accuracy and integrity of service-oriented architecture through analysis, coding, writing clear documentation and problem resolution. This will be achieved through the consistent review of issues and enhancements documented in the incident management and project management system.
Maintain in-depth up-to-date knowledge of standards, guidelines, and industry trends for Data Warehouse Architecture as it relates to reporting and operations by attending user groups and researching new software vendors in the market.
Participates in the planning for retirement of systems programs, and migration of systems infrastructure by providing current state and future state architectural diagrams.
Work closely with Director of the data team, Sr. ETL developers, the primary and Agile Scrum Master to ensure prioritization of corporate and departmental objectives within the portfolio management system.
Champion data quality, integrity and reliability throughout the department by designing data flow models and promoting development best practices with best of breed automation tools.
Provide mentoring to data analyst team members with issues needing technical expertise or complex systems and/or programming knowledge. Provide on-the-job training for new or less experienced data integration team members.
Provide recommendations for the ongoing assessment of database performance and the identification of problem areas by holding regularly scheduled reviews of code and monitoring software with the Architects within the team.
Work with Data and QA analysts to ensure that data, environment and code deployments meet the needs for Data Warehouse testing.
Want to help get your resume to the top? Take a look at the experience we require:
Bachelor’s Degree - Information Technology, Computer Science or related area.
Minimum of five (5) years of experience:
Developing and delivering business intelligence solutions and data architecture.
Working with OLTP and OLAP database models.
In relational database concepts and flat file processing concepts.
Experience applying Data Virtualization tools.
Comprehensive knowledge in software development lifecycle and methodologies (i.e. Agile)
Strong presentation and collaboration skills and ability to communicate job requirements, including formal written documentation
Strong problem solving, time management and organizational skills
Must be able to travel overnight approx. 10% of the time.
Here are some of the preferred skills/experiences we are looking for:
Business Intelligence Technology: SSRS, Power BI, Tableau, MicroStrategy.
ETL Technology: SSIS, DataStage.
Azure cloud services such as, Data Factory, Azure Synapse, Azure Data Lake, Azure Service Bus, Azure functions.
Database/Data Virtualization Technology: SQL Server, Oracle, Alteryx, Denodo, Hadoop, Cloudera
Experience with Cloud offerings and .net development.
So, are you ready to work for the largest voluntary health organization dedicated to fighting heart disease, stroke and other cardiovascular diseases?
Compensation & Benefits
Pay is commensurate with experience; geographic differentials may apply.
Our Rewards & Benefits package not only gives you the total benefits you want, but also goes above and beyond with innovative programs to develop your skills – helping you grow and thrive at the American Heart Association. To learn more about our benefit offerings please visit: https://heart.jobs/rewards-and-benefits/
At American Heart Association | American Stroke Association, diversity, inclusion, and equal opportunity applies to both our workforce and the communities we serve as it relates to heart health and stroke prevention.
This position not a match with your skills? Click here to see other opportunities.
Be sure to follow us on Twitter #TheAHALife
EOE/Protected Veterans/Persons with Disabilities
Posted Date 4 weeks ago (9/23/2021 1:13 PM)
Requisition ID 2021-6817
Job Family Group Business Operations
Job Category Information Technology
Additional Locations Diversity Distribution US - Top 50