What are the responsibilities and job description for the Senior Azure Data & Analytics Engineer (Future Opportunity) position at Metric5?
***Please note, this opportunity is contingent upon receiving award and is not immediately available. ***Location: Washington, DC Metro Area Preferred, but potential for remote/hybridDescription:We are seeking a highly skilled and experienced Senior Azure Data & Analytics Engineer to join our team. The ideal candidate will be a deep expert in the Microsoft Azure Data Platform, responsible for designing, building, and optimizing our next-generation data warehousing and analytics solutions. This role is critical for transforming raw data into high-value, AI-ready assets, ensuring data quality, performance, and accessibility for business intelligence and machine learning applications.Required Skills:Agile Delivery: Experience managing multiple priorities in a fast-paced agile environment.Design and Optimization: Architect, build, and maintain highly scalable and fault-tolerant ETL/ELT data pipelines using Azure Data Factory (ADF) and Synapse Pipelines.Data Warehousing: Lead the development, maintenance, and performance tuning of the data warehouse environment within Azure Synapse Analytics, specifically managing dedicated SQL pools for petabyte-scale data.Modeling: Apply expert knowledge of dimensional modeling techniques (star and snowflake schemas) to create robust, clean, and efficient data models.Semantic Layer: Develop optimized semantic layers and consumption models specifically tailored for reporting and visualization tools like Power BI and Tableau.AI Readiness: Collaborate with data scientists to implement data preparation, cleansing, and feature engineering processes to ensure data assets are high-quality and "AI ready."Data Transformation: Utilize expert-level T-SQL skills to write, optimize, and manage complex queries, stored procedures, and functions necessary for large-scale data transformation and loading.Data Ingestion: Establish and manage efficient data ingestion strategies for diverse, high-volume sources into Azure Data Lake Storage (ADLS Gen2), ensuring proper organization and indexing.Desired Skills:DevOps: Experience with Azure services such as Azure Functions, Azure Key Vault, Azure Repos and Azure DevOps for CI/CD.Language Proficiency: Proficiency in Python or Scala for advanced data processing tasks, as well as experience with languages such as JavaScript, C#, or PowerShell.Platform Development: Development experience with the Azure Power BI ServiceData Sources: Experience using SharePoint Libraries and Lists as data sources.Advanced Concepts: Understanding of development concepts such as parameterization and metadata-driven development.Reverse Engineering: Proficient in reverse engineering other developers' work to understand existing functionalities.Professional Competencies:Customer Focus: Ability to collaborate and communicate with customers to identify requirements.Self-Management: Ability to manage and prioritize own tasks and provide status updates.Leadership: Ability to lead moving and driving work along while also removing development roadblocks.Education: Bachelors in a Technical Discipline – Computer Science, Mathematics, or Data ScienceCredentials: Microsoft Azure Data Engineer certificationYears of Experience: 5 years of experience or moreClearance: Ability to obtain Public Trust High requiredAbout Metric5Metric5 is a small business with big company benefits. We have a passionate team of smart, fun, caring professionals, and we are here for the long haul. Join our growing team in a business where your contributions make an enormous impact. Our organization offers a comprehensive employee benefits package, continuous professional development, with a best in class company culture that is enjoyable to work in and supports the growth of each of our professionals.Our benefits include:Health & Dental Insurance with 100% of individual coverage paid for by the companyVision InsuranceLife & Short Term Disability Insurance401K with company match (employees are immediately vested)Paid Vacation9 Paid Holidays per year (plus 2 paid floating holidays)Parental LeaveEmployee BonusesProfessional Development Reimbursement ProgramTuition Assistance ProgramMetric5 is an Equal Opportunity Employer. All qualified applicants will receive considerationfor employment without regard to race, color, religion, sex, sexual orientation, gender identity,national origin, disability, or status as a protected veteran.
Salary : $138,200 - $182,200