Engineer, Data & Analytics, 1

Day & Zimmermann Company; King of Prussia (PA); On-site; USD 75,000 - 122,000; Full time

Benefits offered by this job

Medical, Dental, Vision

Paid parental leave

Discount programs

Job summary

Day & Zimmermann Company seeks a Data & Analytics Engineer 1 to develop and support governed enterprise data, analytics, applications, and AI solutions within established architecture. You’ll create reusable Microsoft Fabric data products, semantic models, and AI-enabled assets for enterprise analytics and workflows.

The role emphasizes building robust data pipelines, semantic models, DAX logic, and Power BI assets, while ensuring security, governance, and reliable deployment across

Qualifications

• Bachelor's Degree in Arts/Sciences (BA/BS) in IT, Computer Science, Data Engineering, Machine Learning, or a related field, or equivalent related professional experience required
• Less than 1 year relevant professional experience in data engineering, analytics engineering, application development, AI engineering, or a related discipline; relevant internship, co-op, trainee, or comparable hands-on professional experience may qualify

Responsibilities

• Develop, test, deploy, and maintain governed enterprise data products in Microsoft Fabric, including ETL/ELT pipelines, notebooks, Lakehouse structures, and EDW models.
• Build and maintain semantic models, DAX logic, Power BI solutions for enterprise reporting and self-service use cases.
• Develop and support web applications, APIs, AI agents, and application harnesses using Microsoft Fabric capabilities.
• Analyze business requirements to develop technical specifications and implement solutions.
• Implement security, governance, logging, monitoring, and CI/CD deployment practices for reliable production solutions.
• Maintain legacy data and reporting solutions including SAP HANA and SAP Analytics Cloud.

Skills

ETL/ELT

SQL modeling

Power BI

Python PySpark

Git CI/CD

Data security

Education

BA/BS in IT/CS

Tools

Microsoft Fabric

Power BI

DAX

Python

Job description

United States, Pennsylvania, King of Prussia

Job Description

Job Summary The Data & Analytics Engineer 1 develops and supports governed enterprise data, analytics, application, and AI solutions within established architecture and development standards, with guidance from more experienced team members. The role contributes to reliable, reusable Microsoft Fabric data products, semantic models, applications, and AI-enabled solutions that support enterprise analytics, self-service, and business workflows.

Responsibilities

• Develop, test, deploy, and maintain governed enterprise data products in Microsoft Fabric, including ETL/ELT pipelines, notebooks, Lakehouse structures, and EDW fact and dimension models, using established architecture, modeling, naming, data-quality, and CI/CD standards. Apply data engineering principles to analyze source data, evaluate data transformation requirements, and determine appropriate technical approaches for developing and maintaining enterprise data products within established architecture standards. 25%
• Build and maintain reusable semantic models, governed DAX business logic, Power BI solutions, and related analytics assets that provide consistent data and business logic for enterprise reporting and self-service use cases. 20%
• Develop and support web applications, APIs, AI agents, and AI application harnesses using approved development frameworks and Microsoft Fabric capabilities, following established patterns for security, reliability, and reuse. 15%
• Analyze defined business requirements and workflows to develop technical specifications, evaluate solution alternatives, and determine appropriate implementation approaches. Collaborate with stakeholders and more experienced engineers to validate designs, resolve complex technical issues, and deliver functional solutions. 15%
• Implement established security, access, governance, logging, monitoring, alerting, error-handling, documentation, and DEV-to-PRD deployment practices, and troubleshoot assigned production solutions to support reliability and service expectations. Independently analyze and diagnose assigned technical issues, applying specialized knowledge to identify root causes and recommend corrective solutions. Escalate unusual or complex issues requiring additional technical guidance or management review. 15%
• Maintain assigned legacy data, reporting, and planning solutions, including SAP HANA, BusinessObjects, and SAP Analytics Cloud, while supporting technical-debt reduction and approved modernization or retirement activities. 10%

KSAs (Knowledge, Skills, and Abilities)

• Working knowledge of data engineering and analytics engineering concepts, including ETL/ELT, relational data, SQL, dimensional modeling, and governed data products.
• Hands-on capability with Microsoft Fabric and related technologies, including pipelines, notebooks, Python/PySpark, Lakehouse architecture, semantic models, DAX, and Power BI.
• Working knowledge of modern application and AI development concepts, including Python, JavaScript/TypeScript, APIs, web frameworks, coding agents, AI agents, and AI application harnesses.
• Working knowledge of software development practices, including Git, CI/CD, testing, peer review, logging, monitoring, error handling, documentation, and production support.
• Working knowledge of data security and governance practices, including authentication, authorization, role-based access, row-level and object-level security, and protection of enterprise data.
• Ability to analyze defined business requirements, troubleshoot technical issues, and communicate solution details with business stakeholders and technical team members.

Minimum Qualifications

• Bachelor's Degree in Arts/Sciences (BA/BS) in IT, Computer Science, Data Engineering, Machine Learning, or a related field, or equivalent related professional experience required
• Less than 1 year relevant professional experience in data engineering, analytics engineering, application development, AI engineering, or a related discipline; relevant internship, co-op, trainee, or comparable hands-on professional experience may qualify. required

Compensation and Benefits

In compliance with this state's pay transparency laws, the salary range for this role is $75,280 - $122,330. This is not a guarantee of compensation or salary, as final offer amount may vary based on factors including but not limited to experience and geographic location. (The specific programs and options available to an employee may vary depending on date of hire, schedule type, and the applicability of collective bargaining agreements).

We care about our employees and it shows. Our staff receive a competitive salary and a comprehensive benefits package which includes medical/Rx, dental and vision coverage; life, AD&D and disability insurance; flexible spending accounts; 100% paid maternity leave for up to 12 weeks, parental leave, family leave, other paid time off; voluntary benefits and discount programs to meet our employees' individual needs including pet insurance for our furry family members!