IT Sr. Data Warehousing Programmer (Job Code: 2413816)

$127,720 - $127,720/Yr

Henry Ford Health - Detroit, MI

Full-time

Detroit, MI

Ambulatory Health Care Services

About the position

The position involves the design, development, and maintenance of data warehouses, focusing on creating end-to-end Business Intelligence solutions. The role requires in-depth analysis of data models and business processes, along with the implementation of best practices in data management and reporting. The candidate will also be responsible for production support and troubleshooting in a fast-paced environment.

Responsibilities

• Design, develop, and maintain data warehouses.
• Perform in-depth analysis of data models and business processes.
• Implement complete end-to-end Business Intelligence solutions using industry best practices.
• Assist with metadata repository management activities.
• Prepare and implement data verification and testing methods for operational and performance reports.
• Create reports, dashboards, and models for business analytics on web and mobile platforms.
• Perform administrative activities including installation, configuration, security implementation, upgrades, and patches to Cognos Analytics.
• Develop custom SQL queries to gather and integrate data from multiple sources.
• Troubleshoot application and data issues as they arise.
• Provide production support, including on-call duties, and manage new projects.
• Work with Business Analysts to understand functional requirements.
• Develop implementable technical designs.
• Utilize knowledge of complete SDLC and various tools such as IBM Cognos, Power BI, Tableau, SQL, and Python to perform assigned duties.
• Research and recommend alternative design solutions where appropriate.
• Analyze requirements and support the design and development of prototypes.
• Collaborate with users/business analysts to fine-tune the data warehouse and make recommendations.

Requirements

• Bachelor's Degree in Computer Science, Electrical Engineering, Computer Engineering, Information Technology, Engineering Management, or a related field (equivalent foreign degree accepted).
• Five (5) years of experience in a related position such as Database Analyst, BI Developer, Business Systems Analyst, or Programmer Analyst-Database Analyst.

Benefits

• Competitive salary of $127,720 per year.