DECAL Analytics Engineer

Launch Your Career with Cook Systems

Ready to elevate your career? Cook Systems, a certified veteran-owned IT consulting firm, has been transforming businesses and careers since 1990. Whether you’re aiming to work with a Fortune 500 company or a small business, we’ve got you covered. 

Our core values—integrity, investment, and innovation—drive everything we do, ensuring you grow and succeed in a dynamic, supportive environment. We understand the importance of work-life balance and personal growth. Our cutting-edge IT consulting partners and FastTrack talent program are designed to help you excel.

Join our forward-thinking team where excellence and creativity are valued every day. Check out what our associates have to say on Glassdoor. Ready to take your career to new heights? Cook Systems is where your journey to success begins!

Summary:

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.

Responsibilities:

• 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.
• Implement Delta Lake for data versioning, ACID transactions, and schema enforcement.
• Integrate Databricks with other Azure services like Azure One Lake, Azure ADLS Gen2, and Microsoft Fabric.
• Collaborate with 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.
• 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.
• 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.
• Support CI/CD pipelines for data workflows using Azure DevOps.
• Assist in monitoring, logging, and performance tuning of data jobs and clusters.

Required Qualifications:

• Bachelor’s degree in computer science, data engineering, or a related field.
• 3+ years of experience in data engineering or analytics engineering roles.
• 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).
• Familiarity with data modeling, data governance, and data security best practices.
• Strong understanding of ETL/ELT processes, data quality, and schema design.

#L1-Hybrid 

Why Work with Us

At Cook Systems, we don’t just offer jobs—we build futures. Our team is the heart of everything we do, and we’re committed to supporting you with benefits that go beyond the basics. We want you to feel secure, valued, and empowered from the very beginning of your journey with us. When you join Cook Systems, here’s what you can look forward to:

• Your Health, Your Way: Choose from two comprehensive medical plans through Blue Cross Blue Shield, complete with dental and vision coverage. With access to one of the nation’s largest networks, you’ll get the care you need for yourself and your family—wherever life takes you.
• Peace of Mind, Every Step of the Way: Protect what matters most with life, critical illness, and accident insurance through Unum. Because your loved ones deserve security no matter what the future holds.
• Flexibility for Life’s Needs: Save money and plan ahead with a Flexible Spending Account and Daycare FSA through Navia, helping you manage healthcare and dependent care expenses on your terms.
• Bridging the Gaps: Unexpected costs? No problem. Our Health Gap Insurance through Sunlife helps ensure you’re covered when it counts.
• Your Future Starts Now: Dream big with our 401(k) retirement plan through The Standard. After just six months, you will be eligible to participate, because your future deserves a strong foundation.

At Cook Systems, you’re not just another employee—you’re a vital member of our team. Here, your ideas matter, your contributions shine, and your career will thrive. Together, we innovate, grow, and celebrate success every step of the way. Are you ready to be part of something bigger? Let’s build the future together at Cook Systems.

#IND1 #LI-CS1