IT Sr. Data Warehousing Programmer
Responsible for the design, development, production support, enhancement, and maintenance of the data warehouses; perform in-depth analysis of data models and business processes; design, develop and 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 the web and mobile consumption; perform administrative activities including installation, configuration, security implementation, upgrades and patches to Cognos Analytics; develop custom SQL queries to gather and integrate data from across multiple data sources; troubleshoot application and data issues as they arise; provide production support, including on-call duties in a fast-paced environment, as well as new projects; work with Business Analysts to gain an understanding of functional requirements; develop implementable technical designs; utilize and apply knowledge of complete SDLC, IBM Cognos Report Studio, Power Cubes, Framework Manager, Power BI, Tableau, SQL, PL/SQL, DataStage, JavaScript, XML, Unix, Python, Microsoft SQL Server, and DB2 to perform assigned duties; research and recommend alternative design solutions where appropriate; analyze requirements and provide support for the design and development of prototypes; and work with the users/business analysts to fine tune the data warehouse and make recommendations.
Location : Detroit, Michigan and multiple undetermined worksites throughout the US.
"DNS"
#LI-DNI"
Education: Bachelor’s Degree in Computer Science, Electrical Engineering, Computer Engineering, Information Technology, Engineering Management, or in a related field of study (will accept equivalent foreign degree);
Experience: Five (5) years in the position above, as a Database Analyst, as a BI Developer, as a Business Systems Analyst, as a Programmer Analyst-Database Analyst, or in a related occupation;
Other Requirements: Experience must include five (5) years use of all the following: IBM Cognos Report Studio, Power Cubes, Framework Manager, Power BI, Tableau, Unix, PL/SQL, DataStage, XML, Python, Microsoft SQL Server, and DB2.
Will also accept any suitable combination of education, training, and/or experience.
Additional Details
This posting represents the major duties, responsibilities, and authorities of this job, and is not intended to be a complete list of all tasks and functions. It should be understood, therefore, that incumbents may be asked to perform job-related duties beyond those explicitly described above.
Overview
Henry Ford Health partners with millions of people on their health journey, across Michigan and around the world. We offer a full continuum of services – from primary and preventative care to complex and specialty care, health insurance, a full suite of home health offerings, virtual care, pharmacy, eye care and other health care retail. With former Ascension southeast Michigan and Flint region locations now part of our team, Henry Ford’s care is available in 13 hospitals and hundreds of ambulatory care locations. Based in Detroit, Henry Ford is one of the nation’s most respected academic medical centers and is leading the Future of Health: Detroit, a $3 billion investment anchored by a reimagined Henry Ford academic healthcare campus. Learn more at henryford.com/careers.
Benefits
The health and overall well-being of our team members is our priority. That’s why we offer support in the various components of our team’s well-being: physical, emotional, social, financial and spiritual. Our Total Rewards program includes competitive health plan options, with three consumer-driven health plans (CDHPs), a PPO plan and an HMO plan. Our team members enjoy a number of additional benefits, ranging from dental and eye care coverage to tuition assistance, family forming benefits, discounts to dozens of businesses and more. Employees classified as contingent status are not eligible for benefits.
Equal Employment Opportunity/Affirmative Action Employer
Equal Employment Opportunity / Affirmative Action Employer Henry Ford Health is
committed to the hiring, advancement and fair treatment of all individuals without regard to
race, color, creed, religion, age, sex, national origin, disability, veteran status, size, height,
weight, marital status, family status, gender identity, sexual orientation, and genetic information,
or any other protected status in accordance with applicable federal and state laws.