Job description

Description • Under general supervision, combines strong technical skills with knowledge of the database administration. • Works on one or more projects of high complexity. • 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. • 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 DECAL's 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: • Dimensional modeling • Real-time data modeling patterns • 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 • Support CI/CD pipelines for data workflows using Azure DevOps. • Assist in monitoring, logging, and performance tuning of data jobs and clusters. Qualifications: • Bachelor's 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. • 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): Microsoft Fabric Analytics Engineer. • Strong analytical and problem-solving abilities. • Excellent communication skills for technical and non-technical audiences. • Experience working with government stakeholders. Benefits: Healthcare Insurance: Synectics offers eligible employees and their dependents healthcare coverage through BlueCross BlueShield of Illinois. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Premiums are subsidized by Synectics. Dental Insurance: Synectics offers eligible employees and their dependents a dental plan through MetLife. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Vision Insurance: Synectics offers eligible employees vision insurance through VSP. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics.401(k) Plan: The Synectics Inc. Investment Savings Retirement Plan. Synectics offers all employees who are 21 years of age or older the opportunity to invest in the 401(k) Plan on the first enrollment date that is at least 30 days after employment begins. Enrollment dates are each January 1st, April 1st, July 1st, and October 1st. Technical Certification Bonus: Synectics is pleased to award its employees a bonus of up to $500 for an approved professional certification. In determining the bonus amount, Synectics will consider the cost of the test(s) for any certification relating to your current position, achieved during your employment with us. Only one Certification Bonus per calendar year may be awarded per employee. Only current, active employees will be eligible to receive this bonus. It will be awarded 90 days after the Synectics office has received documentation confirming the successful completion of the certification. Synectics is an equal opportunity employer.

Requirements