Designs, develops, and supports ETL and data warehouse/data lakehouse integrations. Builds and schedules ingestion and transformation jobs, debugs production pipelines, documents solutions, participates in planning, and mentors junior engineers. Works with databases and big data tools and may support occasional off-hours incidents.
Primary City/State:
Virtual - ArizonaCategory:
IT Database AdministrationShift:
DayDepartment:
Information TechnologyGreat care starts with great people. (Like you.)
At HonorHealth, you’ll find something special. From humble beginnings in 1927 to one of Arizona’s largest nonprofit healthcare systems, our culture is built on warmth and neighborly kindness. Behind every smile is a highly skilled professional with deep expertise and an unwavering dedication to what matters most — caring for the health and well-being of people and communities across the greater Phoenix area.
Responsibilities:
JOB SUMMARY
The Data Engineer II ICP designs, develops, codes, implements, and supports Integration processes and Data Warehouse activities. Data Engineer II works closely with the business and translates the requirements into technical specifications to deliver a robust scheduled job to ingest and disseminate the information. Data Engineer II possesses programming skills to develop, customize and manage integration tools, databases, warehouses, and analytical systems. Data Engineer II monitors, troubleshoots and supports the production data pipeline jobs that transfer data to and from the databases. Data Engineer II mentors' other junior members on best practices and design patterns. Experience in utilizing data Ingestion, data transformation and data quality tools, leveraging tools such as the Unified Catalog or Microsoft Purview, will be highly valued and differentiated.
ESSENTIAL FUNCTIONS
- Code, test, and implement integration software to ETL solution. Develop efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data lake house/warehouse. Schedule and integrate application/software logs to monitoring application. Implement stored procedures and effectively query the Storage systems (Data Lakehouse/Data Warehouse, MySQL, Oracle, SQL Server) database.
- Debug and troubleshoot errors and provide required support to the production jobs.
- Produce in-depth documentation of all development, policies and procedures.
- Participate in development planning sessions, weekly team status meetings and create/update appropriate project management documentation as required.
- Available for occasional off-hours emergencies. support activities related to on call procedures.
- Maintain current knowledge in new and existing software to ensure productivity, capability, and return on investment.
- Performs other duties as assigned.
EDUCATION
- Bachelors Computer Science or related field Required
- Masters Computer Science or related field Preferred
EXPERIENCE
- 2 years, Data Lake House or Enterprise Data Required
- 2 years, Database development (Python, SQL, PL/SQL, Bash) Required
- 2 years, Experience Big Data (Data Bricks or Apache Spark or similar) Required
- 3 years, Data Engineering experience with any integration/ETL tool/Application. Required
- 1 year, Experience with cloud technologies such as Azure or AWS Preferred
- 2 years, Healthcare or related experience Preferred
LICENSE AND CERTIFICATIONS
We're all in for your career.
Similar Jobs
Consumer Web • Healthtech • Professional Services • Social Impact • Software
Build and own analytics and AI-driven reporting for Care Partnerships. Create self-service insights, predict partner health, prioritize outreach, instrument experiments and launch analytics infrastructure to scale referrals and partner relationships.
Top Skills:
Ai ToolsAnalyticsData ModelingReportingSQL
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound and warm sales leads, consult customers on insurance needs, match appropriate coverages, close policies, complete paid licensing and training, and work scheduled shifts remotely with required workspace and wired high-speed internet.
Top Skills:
PcWired High-Speed Internet (100 Mbps Down / 20 Mbps Up)
AdTech • Consumer Web • Digital Media • eCommerce • Marketing Tech
Plan, write, and optimize newsletter and push-notification content to drive traffic and revenue. Use analytics and reporting tools to inform content strategy, coordinate with editorial, production, and analytics teams, and develop marketing copy and deployment processes to meet audience engagement goals.
Top Skills:
ExcelGoogle AnalyticsGoogle SheetsLookerMicrostrategy
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
