Location: Washington, DC Metro Area Preferred, but potential for remote/hybrid
Description:
We are seeking a highly skilled and experienced Senior Azure Data & Analytics Architect 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 Service
- Data 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 Science
Credentials: Microsoft Azure Data Engineer certification
Years of Experience: 5+ years of experience or more
Clearance: Ability to obtain Public Trust High required
About Metric5
Metric5 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 company
- Vision Insurance
- Life & Short Term Disability Insurance
- 401K with company match (employees are immediately vested)
- Paid Vacation
- 9 Paid Holidays per year (plus 2 paid floating holidays)
- Parental Leave
- Employee Bonuses
- Professional Development Reimbursement Program
- Tuition Assistance Program
Metric5 is an Equal Opportunity Employer. All qualified applicants will receive consideration
for employment without regard to race, color, religion, sex, sexual orientation, gender identity,
national origin, disability, or status as a protected veteran.
