Overview:
TekWissen is a global workforce management provider headquartered in Ann Arbor Michigan that offers strategic talent solutions to our clients worldwide. Our client provides a full range of services including web portal providing information on the state business and economic development public safety Learning law justice health education Corrections transportation IT Social Services and culture. It also supplies information on government services and current job openings.
Position: DECAL Analytics Engineer
Location: Atlanta GA 30334
Duration: 12 Months
Job Type: Contract
Work Type: Hybrid
Job Description:
-
The Analytics Engineer will contribute to our modern data estate strategy by developing scalable data solutions using Microsoft Fabric and Azure Databricks.
-
This role will be instrumental in building resilient data pipelines transforming raw data into curated datasets and delivering analytics-ready models that support enterprise-level reporting and decision-making.
Key Responsibilities:
-
Data Engineering & Pipeline Development
-
Build and maintain ETL/ELT pipelines using Azure Databricks and Microsoft Fabric.
-
Implement medallion architecture (Bronze Silver Gold layers) to support data lifecycle and quality.
-
Develop real-time and batch ingestion processes from IES Gateway and other source systems.
-
Ensure data quality validation and transformation logic is consistently applied.
-
Use Python Spark and SQL in Databricks and Fabric notebooks for data transformation.
-
Delta Lake: Implementing Delta Lake for data versioning ACID transactions and schema enforcement.
-
Integration with Azure Services: Integrating Databricks with other Azure services like Azure One Lake Azure ADLS Gen2 and Microsoft fabric.
Data Modeling & Curation
-
Collaborate with the Domain Owners to design dimensional and real-time data models.
-
Create analytics-ready datasets for Power BI and other reporting tools.
-
Standardize field naming conventions and schema definitions across datasets.
Data Governance & Security
-
Apply data classification and tagging based on DECALs data governance framework.
-
Implement row-level security data masking and audit logging as per compliance requirements.
-
Support integration with Microsoft Purview for lineage and metadata management.
Data Modeling:
Reporting & Visualization Support
-
Partner with BI developers to ensure data models are optimized for Power BI.
-
Provide curated datasets that align with reporting requirements and business logic.
-
Create BI dashboards and train users.
DevOps & Automation
Required Qualifications:
-
Bachelors degree in computer science Data Engineering or related field.
-
3 years of experience in data engineering or analytics engineering roles.
-
Advanced SQL: Proficiency in advanced SQL techniques for data transformation querying and optimization.
-
Hands-on experience with:
-
Azure Databricks (Spark Delta Lake)
-
Microsoft Fabric (Dataflows Pipelines OneLake)
-
SQL and Python (Pandas PySpark)
-
SQL Server 2019
-
Familiarity with data modeling data governance and data security best practices.
-
Strong understanding of ETL/ELT processes data quality and schema design.
Preferred Skills:
-
Experience with Power BI datasets and semantic modeling.
-
Knowledge of Microsoft Purview Unity Catalog or similar governance tools.
-
Exposure to real-time data processing and streaming architectures.
-
Knowledge of federal/state compliance requirements for data handling
-
Familiarity with Azure DevOps Terraform or CI/CD for data pipelines.
Certifications (preferred):
Soft Skills:
-
Strong analytical and problem-solving abilities.
-
Excellent communication skills for technical and non-technical audiences.
-
Experience working with government stakeholders.
TekWissen Group is an equal opportunity employer supporting workforce diversity.