Data Engineer - Analytics

We are looking for a motivated Data Engineer with hands-on experience in SQL Server, SSIS, Azure cloud data tools, and Power BI to join our team. The ideal candidate will be responsible for building and maintaining efficient data pipelines, supporting cloud-based data integrations, and delivering impactful business intelligence solutions. This is a full-time, in-person role located near UCP, offering an opportunity to contribute directly to the organization’s data-driven decision-making processes.

Key Responsibilities
Develop, optimize, and maintain ETL/ELT pipelines across both on-premises and Azure cloud environments. You will design and manage SQL Server objects such as tables, views, stored procedures, and functions to ensure robust data architecture. Building data ingestion and transformation workflows using SSIS, Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure Synapse Analytics, and basic exposure to Databricks is essential.

Create and manage Power BI datasets, dataflows, DAX measures, and interactive dashboards to meet reporting requirements. Ensuring data quality, reliability, and timely availability across systems will be a critical part of your role. You will troubleshoot pipeline failures, performance bottlenecks, and data inconsistencies to maintain smooth operations.

Collaboration with analysts and business users to understand their reporting needs and deliver appropriate solutions is expected. Additionally, you will document workflows, data models, and standard operating procedures to maintain clear and accessible records for the team.

Required Qualifications
Candidates should have 1 to 3 years of experience as a Data Engineer, BI Developer, or in a similar capacity. Strong proficiency in MS SQL Server and T-SQL programming is required. Practical experience with Azure data tools, including Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), and Azure Synapse Analytics, is essential.

Expertise in Power BI is necessary, covering report and dashboard creation, DAX formula writing, and data modeling. A solid understanding of ETL/ELT processes and star/snowflake data modeling techniques is also required to succeed in this role.

Preferred Qualifications and Additional Information
Basic exposure to Databricks is considered a plus. Applicants should be comfortable working on-site at the location near UCP. During the recruitment process, candidates may be asked about their current and expected salary to ensure alignment with the role’s compensation framework.

This position offers the chance to work in a dynamic environment where your technical skills will have a direct impact on enhancing business intelligence capabilities and supporting data-driven strategies. If you are passionate about data engineering and eager to contribute to meaningful projects, this role provides an excellent platform for professional growth.