Health Alliance Plan · 1 day ago
IT Data Warehousing Programmer
Detroit, MI
Full-time
Onsite
Mid, Senior Level
$104K/yr - $104K/yr
4+ years expHealth Alliance Plan is seeking an IT Data Warehousing Programmer responsible for the design, development, and maintenance of data warehouses. The role involves troubleshooting issues, providing production support, and collaborating with business analysts to define requirements and develop documentation.
Health CareHealth InsuranceInsuranceLife Insurance
Responsibilities
Responsible for the design, development, production support, enhancement, and maintenance of the data warehouses
Create and update of all Project-related artifacts including high and low-level design documents
Code the job as per the standards, developing unit test script as well as integrating test script documents and Run book creation for scheduling
Troubleshoot application issues and data issues as they arise
Provide production support including on-call duties in a 24x7 environment as well as new projects
Participate in requirements definition sessions to gain a general perspective on the business objectives and business problems that is to be addressed by the system
Work with Business Analysts to gain an understanding of functional requirements
Work with Business Analysts to develop design documents
Design and develop prototypes and work with the senior personnel to fine tune the data warehouse and make recommendations, including DB and ETL job tuning
Participate in code/design reviews to verify that quality standards and functional/technical requirements are met
Design, code, test and implement moderately complex programs
Develop appropriate programs and systems documentation according to established IT standards
Create test scenarios and develop test plans to be used in testing the business applications in order to verify that client requirements are incorporated in the system design
Analyze testing results throughout the project
Support production systems by helping resolve problems, providing timely follow-up on problem report, and optimizing performance and streamlining processes
Participate in technical reviews and inspections to verify 'intent of change' is carried out through the entire project
Provide support with escalation response to production issues/errors
Perform root cause analysis and application resolution
Utilize and apply knowledge of cloud services/platforms, Azure, AWS, and Google to complete tasks
Utilize Modern Data Solutions Architecture, Data Lakes/Warehouses/Marts, Operational Data Hubs, and Smart Adaptors for performing duties
Apply development skills including DevOps, Python, Scala, SQL, TSQL, and Scripting Languages, as well as Data Storage/Processing/Framework, ADLS Gen2, Azure Function Apps/Logic Apps, Azure DevOps, and Azure Synapse Analytics in order to address assignments
Utilize and apply knowledge of ETL, Data Pipelines, Azure Data Factory, Azure Databricks, Data Consumption, File Validations, Reject Handling, Audit-Balance-Control, Standard Data Feeds, Healthcare Payer Operational Applications, Facets, IKA, Care Radius, Pega, Salesforce Health Cloud, Genesys, Multi-tier Data solutions, Autosys, DB2, Teradata, UNIX, SQL Server, IBM DataStage, XML, Complex flat files, RDBMS, Power BI, Shell Scripts, Oracle, PL/SQL, and ETL tools/jobs to perform assigned duties
Provide on call second-level escalation response for client issues and application problem tickets
Ensure proper documentation and on-time delivery of all technical artifacts and deliverables
Qualification
Required
Bachelor's Degree in Computer Science, Electrical Engineering, Computer Engineering, Information Technology, or in a related field of study (will accept equivalent foreign degree)
Four (4) years in the position above, as a Technology Lead, as a Data Warehousing Lead, as an ETL Technology Analyst, as a Sr. Systems Analyst, or in a related occupation
Experience must include four (4) years use of all the following: Azure Data Factory, Azure Databricks, IBM DataStage, SQL, Azure Synapse Analytics, Oracle, Facets, IKA, Care Radius, Salesforce Health Cloud, Genesys, Azure Function Apps/Logic Apps, Azure DevOps, and Autosys
Company
Health Alliance Plan
Health Alliance Plan is a nonprofit health plan company that provides health coverage to individuals, companies, and organizations.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Michael A. Genord, M.D., MBA
President and CEO Health Alliance Plan, Executive Vice President Henry Ford Health System
Merrill Hausenfluck
Chief Financial Officer
Recent News
2025-08-28
Company data provided by crunchbase