• ETL Data Warehouse Concepts Schema Design Computer…

    COOLSOFT (Atlanta, GA)


    ETL Data Warehouse Concepts Schema Design Computer Science Engineer

     

    (Jobs in Geo

     

    Requirement id 154470

     

    Job title Engineer

     

    Job location in Georgia, GA

     

    Skills required Data Engineering, Power BI, ETL, Data Warehouse Concepts Schema Design Co

     

    Open Date 28-Jul-2025

     

    Close Date

     

    Job type Contract

     

    Duration 10 Months

     

    Compensation DOE

     

    Status requirement ---

     

    Job interview type ---

     

    Email Recruiter:coolsoft

     

    Job Description Engineer: Data Engineering, Power BI, ETL, Data Warehouse Concepts Schema Design Co

     

    Start Date :08/25/2025

     

    End Date :06/30/2026

     

    Submission Deadline :07/31/2025

     

    Client Info: DECAL-IT

    Note :

    * Agency Interview Type : Either Web Cam or In Person

    * Hybrid

    Description :

    The Dept. of Early Care & Development (DECAL) is seeking a highly skilled and proactive Data Engineer to join our dynamic team and support the modernization of our data estate. This role is integral to the migration from legacy systems and the development of scalable, secure, and efficient data solutions using modern technologies, particularly Microsoft Fabric and Azure-based platforms. The successful candidate will contribute to data infrastructure design, data modeling, pipeline development, and visualization delivery to enable data-driven decision-making across the enterprise.

    Work Location & Attendance Requirements:

    • Must be physically located in metro Atlanta.

    • On-site: Tuesday to Thursday, per managers discretion

    • Mandatory in-person meetings:

    o All Hands

    o Enterprise Applications

    o On-site meetings

    o DECAL All Staff

    • Work arrangements subject to managements discretion

     

    Experience Required: 5+ years

    Key Responsibilities:

    • Design, build, and maintain scalable ETL/ELT data pipelines using Microsoft Fabric and Azure Databricks.

    • Implement medallion architecture (Bronze, Silver, Gold) to support data lifecycle and data quality.

    • Support the sunsetting of legacy SQL-based infrastructure and SSRS, ensuring data continuity and stakeholder readiness.

    • Create and manage notebooks (e.g., Fabric Notebooks, Databricks) for data transformation using Python, SQL, and Spark.

    • Build and deliver curated datasets and analytics models to support Power BI dashboards and reports.

    • Develop dimensional and real-time data models for analytics use cases.

    • Collaborate with data analysts, stewards, and business stakeholders to deliver fit-for-purpose data assets.

    • Apply data governance policies including row-level security, data masking, and classification in line with Microsoft Purview or Unity Catalog.

    • Ensure monitoring, logging, and CI/CD automation using Azure DevOps for data workflows.

    • Provide support during data migration and cutover events, ensuring minimal disruption.

    Technical Stack:

    • Microsoft Fabric

    • Azure Databricks

    • SQL Server / SQL Managed Instances

    • Power BI (including semantic models and datasets)

    • SSRS (for legacy support and decommissioning)

    Qualifications:

    • Bachelors degree in Computer Science, Information Systems, or related field

    • 5+ years of experience in data engineering roles, preferably in government or regulated environments

    • Proficiency in SQL, Python, Spark.

    • Hands-on experience with Microsoft Fabric (Dataflows, Pipelines, Notebooks, OneLake)

    • Experience with Power BI data modeling and dashboard development

    • Familiarity with data governance tools (Microsoft Purview, Unity Catalog)

    • Solid understanding of ETL/ELT pipelines, data warehousing concepts, and schema design

    • Strong communication and collaboration skills.

    Preferred Qualifications:

    • Certifications such as Microsoft Certified: Fabric Analytics Engineer or Azure Data Engineer Associate

    • Knowledge of CI/CD automation with Azure DevOps

    • Familiarity with data security and compliance (e.g., FIPS 199, NIST)

    • Experience managing sunset and modernization of legacy reporting systems like SSRS

    Soft Skills:

    • Strong analytical thinking and problem-solving abilities

    • Ability to collaborate across multidisciplinary teams

    • Comfort in fast-paced and evolving technology environments

     

    This role is critical to our shif

     

    Call502-379-4456 Ext 100for more details. Please provide Requirement id: 154470 while calling.

     

    Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets