What are the responsibilities and job description for the Data Architect position at Ascension Consulting?
Description
Ascension Consulting is seeking a strategic and technically adept Data Architect to drive enterprise analytics initiatives using the Microsoft data ecosystem. This role blends hands-on data science with leadership responsibilities, guiding a team in delivering scalable, secure, and actionable insights through tools like SQL Server, SSIS, Power BI, and Active Directory to develop and support SSIS/ETL Jobs and Sql Server databases pertaining to agency objectives and goals, public programs, education, research, and other initiatives within a federal civilian agency of the United States government. The role is a part of the Digital Transformation Team providing engineering solutions. This position is Hybrid with 3 days onsite per week at customer site in Washington DC.
Key Responsibilities:
- Lead the design and deployment of predictive models and machine learning algorithms.
- Architect and optimize SQL Server databases and SSIS ETL pipelines for performance and scalability.
- Develop and oversee Power BI dashboards, ensuring alignment with business KPIs.
- Manage secure data access and compliance using Active Directory roles and policies.
- Mentor junior data scientists and analysts, fostering a culture of innovation and excellence.
- Collaborate with cross-functional teams to translate business needs into data-driven strategies.
- Establish best practices for data governance, quality assurance, and model lifecycle management.
- Communicate insights through compelling visualizations and executive-ready storytelling.
Qualifications
Required Skills & Qualifications:
- Must have a Bachelors degree and 5 years of experience in data science, analytics, or business intelligence.
- Prefer technical lead or team lead experience.
- Deep expertise in SQL Server, SSIS, and Power BI.
- Strong understanding of Active Directory for role-based access control.
- Architect and optimize SQL Server databases and SSIS ETL pipelines for performance and scalability.
- Ability to architect end-to-end data solutions and guide technical direction for complex data schemas.
- Experience with Azure Data Factory and Microsoft Fabric for cloud-based data orchestration.
- Excellent communication skills for stakeholder engagement and executive presentations.
- Bachelor’s or Master’s degree in Data Science, Computer Science, or related field.
Nice to Have:
- Familiarity with Azure Synapse, Databricks, or Delta Lake.
- Microsoft certifications (e.g., Azure Data Scientist Associate, Power BI).
- Exposure to CI/CD pipelines and DevOps practices for data workflows.
- Proficiency in Python for statistical modeling and machine learning.
Clearance Requirement:
- Must be eligible to obtain a U.S. Public Trust Clearance
**This hybrid role requires a minimum of three on-site days per week in Washington, DC**
Job Type: Contract
Pay: $85.00 - $90.00 per hour
Application Question(s):
- How many years experience in Azure Data Factory.
- Are you familiar with Azure Synapse, Databricks, or Delta Lake?
- Do you live in the DC/MD/VA area?
- Do you have a GC or are a US citizen?
Work Location: Hybrid remote in Washington, DC 20024
Salary : $85 - $90
