Analytics Engineer
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Our customer is a leading Hospital devoted exclusively to the care of children. Since their start in 1855, they have been the birthplace for countless breakthroughs and dramatic firsts in pediatric medicine. Built on a foundation of delivering safe, high-quality, family-centered care, our customer has fostered medical discoveries and innovations that have improved pediatric healthcare and saved countless children’s lives. Today, families facing complex conditions come to our customer from all over the world, and their compassionate care and innovation has repeatedly earned them a spot on the U.S. News & World Report's Honor Roll of the nation's best children's hospitals.
We are seeking an Analytics Engineer for a WFH Consulting opportunity.
The Analytics Engineer acts as a bridge between a Data Engineer and a Data Analyst. This position
is primarily responsible for modeling raw data sets into curated, reusable, trusted data sets which power analytics across the enterprise. These data sets will serve as the single source of truth for data and enable self-service analytics. In addition to the development of data models, this role is responsible for maintaining data quality within these data sets via the use of monitoring, testing, and automation. An additional component of the role is to improve the effectiveness of data analysts and data scientists. This may be via providing technical expertise in query development, extending data models via the addition of new metrics, and/or consulting on software development practices. The Analytics Engineer owns the entire workflow of data associated with their domain, data pipeline development, ELT performance, timely loading of data sets, and maintenance.
This role will work within various business units and partner with data analysts and data scientists to obtain a deep understanding of operational data and develop scalable data products which empower data-driven decision making across the enterprise.
- Collaborate with business subject matter experts, data analysts, and data scientists to understand/identify the opportunities to develop well-defined, integrated, re-usable data sets which power analytics.
- Codify reusable data access patterns to speed up time to insights.
- Perform Logical and Physical data modeling with an agile mindset.
- Build automated, scalable, test-driven ELT pipelines.
- Utilize software development practices such as version control via Git, CI/CD, and release management
- Build data products using various visualization, BI tools and data science tools.
- Collaborate with Data Engineers, DevOps engineers and architects on improvement
- opportunities for DataOps tools and frameworks.
- Implement data quality frameworks and data quality checks.
- Help define analytical product roadmap to drive the business goals and superior quality outcomes.
- Work with Data Scientists, Statisticians and Machine learning engineers to
implement/scale advanced algorithms to solve health care, operational and quality challenges.successfully meets its deliverables each sprint. Skills Required
- Work independently and effectively manage one’s time across multiple priorities and projects.
- Make recommendations about platform adoption, including technology integrations, application servers, libraries, and frameworks.
- Participate in a shared production on-call support model.
- Be a critical part of a scrum team in an Agile environment, ensuring the team
Candidates should possess a minimum of six (6) years of experience working in Data and Analytics landscape. It is preferred candidates possess eight (8) years of experience working in Data and Analytics landscape. Candidates should possess at least one (1) year of experience working with at least one of the public cloud platforms such
AWS/Azure/GCP.
- Strong SQL, Data Modeling and Data Warehousing fundamentals.
- Experience with data integration tools: DBT, Informatica PowerCenter, MS Integration Services, etc.
- Experience with software development practices; Version Control (Github), code review, CI/CD.
- Experience with big data toolset: Hadoop, Spark, Kafka, Hive, Sqoop, etc.
- Experience working with Business Intelligence Tools (Business Objects) or Visualization tools such as Qlik, Tableau, PowerBI etc.
- Experience with stream-processing systems: IBM Streams, Flume, Storm, Spark-Streaming, etc.
- Good hands-on experience with Linux (RHEL/Debian) operating system.
- Ability to code with other scripting languages such as Python, Bash, Groovy, etc.
- Experience consuming and building APIs.
- Experience utilizing Agile methodology for development.
Preferred Skills & Experience:
- Eight (8) years of experience working in data and analytics landscape.
- Advanced SQL for analytics engineering, including complex transformations, aggregations, and performance tuning.
- Strong dimensional data modeling skills, including design and implementation of fact and dimension tables.
- Hands-on experience with Snowflake as a cloud data warehouse for analytics workloads.
- Experience developing and maintaining analytics models using DBT, including testing and documentation.
- Proven ability to refactor existing analytical data models to support reporting and dashboard migrations.
- Experience supporting enterprise BI platforms, preferably Power BI, including semantic model alignment.
- Strong analytical and problem solving skills, with the ability to evaluate tradeoffs and recommend optimal modeling approaches.
- Experience with Apache Airflow or similar workflow orchestration tools for scheduling and managing analytics pipelines.
- Experience using Python for data transformation, validation, automation, or analytics workflows.
- Familiarity with Agile or iterative delivery practices.
- Experience with version control and modern analytics development practices (e.g., Git, pull requests, code reviews).
- Experience supporting BI platform migrations (e.g., Qlik, Business Objects, or similar to Power BI).
Education
Candidates should possess (not a must) a BA/BS in Computer Science, Computer/Software Engineering, Information Technology or related fields. Relevant professional experience demonstrated technical capability, and a track record of delivering analytics solutions will be weighted more heavily than formal education or certifications.
Pay: $80.00 - $90.00 per hour
Work Location: Remote