Analytics Engineer

This is a fully remote position, open to applicants in District of Columbia, +1 more state.

📋 Description

• Design, develop, and maintain scalable analytics data models and transformation pipelines.

• Convert raw data into reliable, structured datasets that are ready for analytics.

• Create reusable data models and curated datasets to facilitate reporting, dashboards, analytics, and operational decision-making.

• Write and optimize complex SQL queries for large datasets.

• Develop automated processes for data transformation and validation.

• Implement data quality checks, testing practices, and monitoring mechanisms.

• Collaborate with data engineers to enhance data ingestion, transformation, and storage processes.

• Work alongside analysts and business stakeholders to comprehend reporting needs and convert them into scalable technical solutions.

• Support business intelligence dashboards and enterprise reporting systems.

• Maintain comprehensive documentation for data models, transformations, lineage, and business logic.

• Identify and address data quality, consistency, and performance challenges.

• Contribute to enterprise data governance, metadata management, and data standardization initiatives.

• Engage in Agile development activities, technical reviews, and release planning.

• Assist in cloud-based data modernization and analytics projects.

• Ensure all solutions comply with relevant federal security, privacy, governance, and data management regulations.

⛳️ Requirements

• Bachelor's degree in Computer Science, Data Science, Information Systems, Engineering, Mathematics, Statistics, or a related technical field.

• Over 5 years of experience in analytics engineering, data engineering, business intelligence engineering, or a similar data-focused position.

• Advanced skills in SQL and relational data principles.

• Proven experience in developing data models and transformation pipelines.

• Familiarity with modern data warehouses, cloud data platforms, or data lake environments.

• Strong grasp of ETL/ELT concepts and data integration practices.

• Experience in implementing data quality validation and testing.

• Proficiency in Python or another data-centric programming language.

• Knowledge of version control systems and contemporary software development methodologies.

• Strong analytical, troubleshooting, and problem-solving abilities.

• Excellent communication skills with a capacity to collaborate with both technical and business teams.

• Ability to fulfill applicable federal background investigation requirements.

• Prior experience in supporting federal healthcare, health IT, or large-scale federal data programs.

• Experience with healthcare or clinical data settings.

• Familiarity with dbt (Data Build Tool).

• Experience with Snowflake, Databricks, Microsoft Azure, AWS, or comparable cloud data platforms.

• Experience with modern BI tools such as Power BI, Tableau, or Looker.

• Knowledge of data cataloging, lineage, metadata management, and governance.

• Understanding of healthcare interoperability standards like HL7 or FHIR.

• Experience in Agile and DevSecOps environments.

🏝️ Benefits

• Paid sick leave.

• Medical/Dental (optional).

• 401 (k) Retirement Plan (optional).

• Employer Paid Life Insurance.

• Employer Paid Short Term Disability.

• Optional Life Insurance.