Senior Data Analytics Engineer
Job Description
This senior data analytics engineer role is based onsite in Reston, VA, focusing on designing, building, and sustaining scalable analytics solutions using Microsoft Fabric in close collaboration with business partners and technical peers.
Responsibilities
- Design and implement dimensional data models, including fact tables and slowly changing dimensions, to support analytics, reporting, and downstream consumption.
- Develop and maintain data pipelines in Microsoft Fabric, enabling ingestion, transformation, and modeling using a medallion architecture (Bronze, Silver, Gold).
- Construct and maintain data transformations with SQL, SparkSQL, PySpark, and Python within Fabric Notebooks.
- Apply solid database and data modeling practices to deliver performant, reliable, and maintainable analytics solutions.
- Implement machine learning and AI solutions using tools available in the Microsoft Fabric and Foundry ecosystems, with guidance for more advanced use cases as needed.
- Collaborate with business stakeholders to gather requirements, clarify needs, and translate them into effective data solutions.
- Engage in Git-based version control and CI/CD workflows in line with established team practices.
- Adhere to data governance, security, and compliance standards when designing and delivering data, ML, and AI solutions.
- Contribute to team documentation, data standards, and reusable patterns.
- Troubleshoot and enhance existing pipelines, data models, and notebooks to improve reliability and performance.
Requirements
- 5+ years of experience as a Data and Analytics Engineer.
- Strong experience with SQL and dimensional modeling, including fact tables, dimensions, and slowly changing dimensions.
- Proficiency in Python, PySpark, and SparkSQL, with hands-on work in Fabric Notebooks.
- Hands-on experience delivering end-to-end solutions in a Medallion architecture, covering ingestion, transformation, and modeling.
- Working experience with machine learning and AI concepts, including exposure to implementation in Fabric or similar platforms.
- Experience using Git for source control in a collaborative development environment.
- Understanding of data governance and security practices applied to analytics and data platforms.
- Ability to engage effectively with customers, understand business questions, and deliver practical, high-quality solutions.
Technologies
- Microsoft Fabric
- Fabric Notebooks
- SQL
- SparkSQL
- PySpark
- Python
- Git
- Medallion architecture (Bronze, Silver, Gold)
- Foundry ecosystem
- Power BI
Benefits
- Traditional benefits
- Stock ownership through a profit sharing trust
Similar Jobs
