ETL/SSIS Developer

Job Title: ETL/SSIS Developer
Location: Des Moines, IA
Duration: Full Time

Position Purpose:

• Responsible for development of SSRS and PowerBI reports in accordance with business requirements. This position will also support development, deployment and implementation of the Bank’s Data Warehouse (HUB).
• Data Developer role will review documented report specifications, clarify requirement ambiguity, develop report output, and unit test the reports to confirm data accuracy.
• Report Developer may also participate in QA or UAT testing as requested.

Responsibilities/Duties/Function/Tasks:

• Works with Business Intelligence Analysts, internal customers, and external consulting teams to understand reporting requirements.
• Provides recommendations to the internal customers with reporting choices based on future-state reporting needs.
• Develop SSRS and/or PowerBI reports as assigned.
• Unit test reports to confirm data accuracy.
• Work with development teams, architects, management, and business stakeholders to ensure the Hub infrastructure is aligned with business requirements and IT standards.
• Implement data solutions and designs with high quality to ensure alignment with the data architecture and applicable standards.
• Support QA and UAT testing as assigned.
• Quickly troubleshoot and resolve incidents and problems and follow with root cause analysis and solution.
• Actively seek opportunities to improve processes.
• Manage administrative tasks related to this position.
• Ensures reporting solution development is documented in accordance with Data and Reporting Team standards.

Qualifications:

• Knowledge/experience with SQL Server Reporting Services (SSRS).
• Hands on experience with PowerBI strongly preferred.
• Strong analytic skills.
• Strong attention to detail.
• Knowledge/experience with SQL queries and Business Intelligence concepts.
• Able to build and maintain relationships and facilitate collaboration and communication.
• Able to influence without authority.
• Knowledge/experience with ETL, data models and Business Intelligence concepts.
• Excellent oral and written communication and planning skills.
• Able to work independently and collaborate with people at all levels.
• Ability to positively engage, self-motivate and possess a strong desire to learn.

Job Type: Full-time

Work Location: In person