Data Engineer

Milestone Technologies is looking for a Data Engineer to support a client's EDW migration from on-prem (SQL Server 2016) to the Azure Cloud. This role will focus on the data quality and errors for the new data pipes established from the source to the new target cloud database. You will work closely with the team that is designing and building the data pipes as well as the lead business analyst who is working with internal stakeholders defining the data quality requirements and thresholds. You will be responsible for designing and building the processes for measuring data quality, data transmission failures, and data load errors. In addition to this, you will be expected to work with report developers to create dashboards and reports showcasing the data quality. • Translate data requirements for new data quality controls and thresholds into technical designs and specifications • Create automated processes to measure data quality, failures, and errors • Analyze existing systems and data pipes to identify areas for improvement or opportunities to enhance • Continue to help evolve and improve the data quality processes and templates • Profile data sources to understand existing quality issues in the ETL processes • Collaborate on data modeling tasks including recommending and evaluating designs based on Kimball dimensional data modeling practices • Aggregate and combine raw information from different data sources • Explore ways to enhance data quality and reliability including helping with the development of support and remediation processes • Identify opportunities for data acquisition • Develop analytical tools and processes to measure and report data quality • Help adjust and tune existing CI/CD framework and processes (Azure DevOps) as needed to improve data quality • Assist Senior BI Engineer and Senior Data Engineer on innovative technology POCs

At Milestone we strive to create a workplace that reflects the communities we serve and work with, where we all feel empowered to bring our full, authentic selves to work. We know creating a diverse and inclusive culture that champions equity and belonging is not only the right thing to do for our employees but is also critical to our continued success. Milestone Technologies provides equal employment opportunity for all applicants and employees. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, gender, gender identity, marital status, age, disability, veteran status, sexual orientation, national origin, or any other category protected by applicable federal and state law, or local ordinance. Milestone also makes reasonable accommodations for disabled applicants and employees. We welcome the unique background, culture, experiences, knowledge, innovation, self-expression and perspectives you can bring to our global community. Our recruitment team is looking forward to meeting you.