Henry Ford Health
IT Sr. Data Warehousing Programmer | Full Time
Henry Ford Health, Detroit, Michigan, United States, 48228
IT Sr. Data Warehousing Programmer | Full Time
Join to apply for the
IT Sr. Data Warehousing Programmer | Full Time
role at
Henry Ford Health IT Sr. Data Warehousing Programmer | Full Time
1 month ago Be among the first 25 applicants Join to apply for the
IT Sr. Data Warehousing Programmer | Full Time
role at
Henry Ford Health General Summary
Under the general direction of the Enterprise Data Architect, Data Architecture Manager, or EDW Program Manager: this role is responsible for designing, developing, and maintaining enterprise-level data warehouse solutions using Microsoft SQL Server and Microsoft Fabric. The ideal candidate will have a deep understanding of data architecture, ETL processes, performance optimization, and cloud-based data solutions to support the organization's analytics and reporting needs, with a focus on custom SSIS package development and the creation of reusable Fabric data pipelines. Responsibilities will include troubleshooting application and data issues and providing production support (including on-call duties in a 24x7 environment) in addition to executing on new projects. The ideal candidate will have experience using analytical skills to seek out, research and evaluate a variety of options to provide clients with high quality, efficient business processes and solutions that promote efficiency and enterprise-wide standardization. General Summary
Under the general direction of the Enterprise Data Architect, Data Architecture Manager, or EDW Program Manager: this role is responsible for designing, developing, and maintaining enterprise-level data warehouse solutions using Microsoft SQL Server and Microsoft Fabric. The ideal candidate will have a deep understanding of data architecture, ETL processes, performance optimization, and cloud-based data solutions to support the organization's analytics and reporting needs, with a focus on custom SSIS package development and the creation of reusable Fabric data pipelines. Responsibilities will include troubleshooting application and data issues and providing production support (including on-call duties in a 24x7 environment) in addition to executing on new projects. The ideal candidate will have experience using analytical skills to seek out, research and evaluate a variety of options to provide clients with high quality, efficient business processes and solutions that promote efficiency and enterprise-wide standardization.
Principle Duties And Responsibilities
Participates in requirements definition sessions to gain a general perspective on the business objective(s) or business problem that is to be addressed by the system. Works with Business Analysts to gain an understanding of functional requirements. Works with Business Analysts to develop implementable technical designs. Research and recommend alternative design solutions where appropriate. Analyzes requirements, design and develop prototype and work with the users/business analyst to fine tune the data warehouse and make recommendations. Participates in peer/code/design reviews to verify that quality standards and functional/technical requirements are met. Design, code, test and implement moderately complex programs; Develops appropriate programs and systems documentation according to established IT standards. Creates test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated into the system design. Assists in analyzing testing results throughout the project. Enhances existing systems; participates in structured walkthroughs and technical reviews. Supports production systems by helping resolve problems, providing timely follow-up on problem report, optimizing performance and streamlining processes Assists in coordinating developments tasks on projects, problem tickets and provide support to other team members. Provides support, escalation response to production problem issues/errors. Performs root cause analysis and application resolution. Provides on call second-level escalation response for client issues and application problem tickets. Collaborates with work teams, departments, system leadership, staff, other IT groups, and technology vendors to define needs and facilitate solutions. Ensures proper documentation and on-time delivery of all technical artifacts and deliverables. Keeps abreast of new Tools & Technology and functionalities across the application. Promotes teamwork and leads by example. Initiates a personal training plan, continue acquiring skills and knowledge, and pursue an understanding of the organizations business plans and strategies.
Education/Experience Required
Bachelors degree required, Masters degree preferred. Seven (7) years of applicable work experience in a data warehousing environment required; Five (5) years applicable experience in a Healthcare setting preferred. Experience with Epic Clarity and Epic Caboodle preferred. Expertise in Microsoft SQL Server, including T-SQL, SSIS, and performance tuning. Experience with Microsoft Fabric, including data integration, real-time analytics, and cloud-based data management. Knowledge of Power BI or other reporting tools is a plus. Good understanding of HIPAA data Privacy and Security requirements. Previous supervisory experience preferred. Ability to be flexible and work analytically in a problem-solving environment. Good organizational, multi-tasking, and time-management skills. Good communication (written and oral) and interpersonal skills. Proven ability to work independently and as a team member. Experience/exposure to the System Development Life Cycle (SDLC).
Additional Information
Organization: Corporate Services Department: Helios Enter Data Wrhse IT Exp Shift: Day Job Union Code: Not Applicable Seniority level
Seniority level
Associate Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Hospitals and Health Care, Insurance, and Wellness and Fitness Services Referrals increase your chances of interviewing at Henry Ford Health by 2x Sign in to set job alerts for Senior Data Warehouse Engineer roles.
Lead Business Intelligence Developer - Full time - Detroit
Lead Business Intelligence Developer - Populance
Senior/Staff Data Engineer (Fintech team) (Bangkok based, relocation provided)
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Join to apply for the
IT Sr. Data Warehousing Programmer | Full Time
role at
Henry Ford Health IT Sr. Data Warehousing Programmer | Full Time
1 month ago Be among the first 25 applicants Join to apply for the
IT Sr. Data Warehousing Programmer | Full Time
role at
Henry Ford Health General Summary
Under the general direction of the Enterprise Data Architect, Data Architecture Manager, or EDW Program Manager: this role is responsible for designing, developing, and maintaining enterprise-level data warehouse solutions using Microsoft SQL Server and Microsoft Fabric. The ideal candidate will have a deep understanding of data architecture, ETL processes, performance optimization, and cloud-based data solutions to support the organization's analytics and reporting needs, with a focus on custom SSIS package development and the creation of reusable Fabric data pipelines. Responsibilities will include troubleshooting application and data issues and providing production support (including on-call duties in a 24x7 environment) in addition to executing on new projects. The ideal candidate will have experience using analytical skills to seek out, research and evaluate a variety of options to provide clients with high quality, efficient business processes and solutions that promote efficiency and enterprise-wide standardization. General Summary
Under the general direction of the Enterprise Data Architect, Data Architecture Manager, or EDW Program Manager: this role is responsible for designing, developing, and maintaining enterprise-level data warehouse solutions using Microsoft SQL Server and Microsoft Fabric. The ideal candidate will have a deep understanding of data architecture, ETL processes, performance optimization, and cloud-based data solutions to support the organization's analytics and reporting needs, with a focus on custom SSIS package development and the creation of reusable Fabric data pipelines. Responsibilities will include troubleshooting application and data issues and providing production support (including on-call duties in a 24x7 environment) in addition to executing on new projects. The ideal candidate will have experience using analytical skills to seek out, research and evaluate a variety of options to provide clients with high quality, efficient business processes and solutions that promote efficiency and enterprise-wide standardization.
Principle Duties And Responsibilities
Participates in requirements definition sessions to gain a general perspective on the business objective(s) or business problem that is to be addressed by the system. Works with Business Analysts to gain an understanding of functional requirements. Works with Business Analysts to develop implementable technical designs. Research and recommend alternative design solutions where appropriate. Analyzes requirements, design and develop prototype and work with the users/business analyst to fine tune the data warehouse and make recommendations. Participates in peer/code/design reviews to verify that quality standards and functional/technical requirements are met. Design, code, test and implement moderately complex programs; Develops appropriate programs and systems documentation according to established IT standards. Creates test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated into the system design. Assists in analyzing testing results throughout the project. Enhances existing systems; participates in structured walkthroughs and technical reviews. Supports production systems by helping resolve problems, providing timely follow-up on problem report, optimizing performance and streamlining processes Assists in coordinating developments tasks on projects, problem tickets and provide support to other team members. Provides support, escalation response to production problem issues/errors. Performs root cause analysis and application resolution. Provides on call second-level escalation response for client issues and application problem tickets. Collaborates with work teams, departments, system leadership, staff, other IT groups, and technology vendors to define needs and facilitate solutions. Ensures proper documentation and on-time delivery of all technical artifacts and deliverables. Keeps abreast of new Tools & Technology and functionalities across the application. Promotes teamwork and leads by example. Initiates a personal training plan, continue acquiring skills and knowledge, and pursue an understanding of the organizations business plans and strategies.
Education/Experience Required
Bachelors degree required, Masters degree preferred. Seven (7) years of applicable work experience in a data warehousing environment required; Five (5) years applicable experience in a Healthcare setting preferred. Experience with Epic Clarity and Epic Caboodle preferred. Expertise in Microsoft SQL Server, including T-SQL, SSIS, and performance tuning. Experience with Microsoft Fabric, including data integration, real-time analytics, and cloud-based data management. Knowledge of Power BI or other reporting tools is a plus. Good understanding of HIPAA data Privacy and Security requirements. Previous supervisory experience preferred. Ability to be flexible and work analytically in a problem-solving environment. Good organizational, multi-tasking, and time-management skills. Good communication (written and oral) and interpersonal skills. Proven ability to work independently and as a team member. Experience/exposure to the System Development Life Cycle (SDLC).
Additional Information
Organization: Corporate Services Department: Helios Enter Data Wrhse IT Exp Shift: Day Job Union Code: Not Applicable Seniority level
Seniority level
Associate Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Hospitals and Health Care, Insurance, and Wellness and Fitness Services Referrals increase your chances of interviewing at Henry Ford Health by 2x Sign in to set job alerts for Senior Data Warehouse Engineer roles.
Lead Business Intelligence Developer - Full time - Detroit
Lead Business Intelligence Developer - Populance
Senior/Staff Data Engineer (Fintech team) (Bangkok based, relocation provided)
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr