Senior Data Warehouse Developer
As SMG continues to expand its use of BI tools to drive effective decision-making, the Senior Data Warehouse Developer will play an instrumental role of providing actionable insight to key business stakeholders. Under the direction of the Senior Manager of Business Intelligence, the primary responsibility of the Senior Data Warehouse Developer is to develop optimized and effective datasets for analysts and other users across the SMG enterprise, along with supporting business intelligence tools and initiatives. This role is an instrumental member of a team that provides reporting to users across multiple organization structures and thousands of healthcare providers within the SMG business unit on a daily, weekly, and monthly basis. Working with other members of the Business Intelligence & Data Warehouse team, other Analytics and IS teams across Steward, key business stakeholders, and third-party development teams, the Senior Data Warehouse Developer will transform SMG’s analytical data into actionable insights. The Senior Data Warehouse Developer will be expected to develop solutions for projects and initiatives requested by senior leadership from inception through to the final deliverable. The Senior Data Warehouse Developer will also work to automate workflows using Python.
- Develops queries and views for standard and ad hoc reporting, primarily using Microsoft SQL Management Server Studio
- Act as a subject matter expert for translating business requirements into ETL processes
- Partner with business analysts, data engineers, subject matter experts, data architects and third-party developers to identify and develop useful and strategically relevant insights
- Collaborate with senior leaders to actively influence discussions regarding reporting requirements, product roadmap, product design, and infrastructure needs
- Automate workflows using Python and REST APIs
- Act as a subject matter expert on SMG Data Warehouse and Health Catalyst Data Marts
- Recommend approaches in design, architecture, and tools used to increase product effectiveness
- Create and maintain technical design documentation
- Gather requirements from users and other SMEs, perform QA testing, and assist users in UAT
- Act as backup for managing Tableau server, its performance, and automating server tasks
- Expert T-SQL knowledge and significant experience using Microsoft SMSS
- 6+ years of total experience with data warehouse development, engineering, architecture, and/or modeling
- Ability to anticipate how to successfully enable end users to consume and comprehend complex data sets
- Effective communicator, both written and verbally
- Experience automating workflows using Python or R and leveraging standard analytics libraries
- Experience in sourcing data from disparate systems with a good understanding of their data models and ETL workflow
- Bachelor’s Degree in Computer Science, Mathematics/Statistics, Science/Engineering, Management Information Systems, Business, or an equivalent field
- Driven to accomplish goals provided with a ‘can-do’ attitude
- Able to multi-task and effectively prioritize development efforts
- Experience with JIRA and Confluence or other issue tracking products
- Proven documentation and organizational skills
The Ideal Candidate
- Collaborative spirit, contributes to team dynamic
- Creative energy and a sense of humor
- Possesses a myriad of tools in their tool belt to assist in SMG’s continued investment into more robust reporting tools and methodologies
- Able to communicate effectively with non-technical users, provide expertise and strategic recommendations to team
- Able to design processes and products in a scalable manner
- Understands that becoming an effective developer requires a base level understanding of business rules and partners with SME’s to deepen their knowledge of the business
- Experienced managing their individual projects and timelines
- Experienced automating workflows using in Powershell and/or Python REST API’s
- MS in Analytics, a Science, Information Systems, or MBA
- Possesses experience acting as a Tableau server administrator
Steward Health Care is an Equal Employment Opportunity (EEO) employer, Steward Health Care does not discriminate on the grounds of race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, and or expression or any other non-job-related characteristic.
Steward Medical Group is taking additional necessary preparations to ensure patients can receive compassionate care in safe, carefully managed environment with confidence and without fear.
Our Safe and Ready program consists of a rigorous [three-point] standard ensuring patient safety, confidence and convenience.
- Any COVID-19 related care takes place in designated areas away from other patients and their families.
- A stringent cleaning policy has been implemented throughout our facilities.
- A strictly controlled visitor and mask policy is required for patient and colleague safety.
Steward Health Care is the largest private, for-profit health care network in the United States. The company is owned and led by a management team of Steward physicians. Headquartered in Dallas, Texas, Steward employs more than 40,000 health care professionals and operates 35 hospitals across the United States and in the countries of Malta and Colombia which regularly receive top awards for quality and safety. The Steward network includes multiple urgent care centers and skilled nursing facilities, substantial behavioral health services, more than 7,000 beds under management, and approximately 2.2 million full risk covered lives through the company's managed care and health insurance services.
The Steward Health Care Network includes more than 5,000 physicians across 800 communities who help to provide more than 12 million patient encounters annually. Steward Medical Group, the company's employed physician group, provides more than six million patient encounters per year. The Steward Hospital Group operates hospitals in Malta, Colombia and nine states across the U.S., including Arizona, Arkansas, Florida, Louisiana, Massachusetts, Ohio, Pennsylvania, Texas, and Utah. For more information, visit www.steward.org.