Data Engineer - Analytics

We are seeking a motivated Data Engineer with practical experience in SQL Server, SSIS, Azure cloud data tools, and Power BI. The successful candidate will play a key role in building and maintaining data pipelines, supporting cloud-based integrations, and contributing to meaningful business intelligence solutions. This is a full-time, in-person position located near UCP.

Key Responsibilities

- Develop, optimize, and maintain ETL/ELT pipelines across both on-premises and Azure cloud environments.
- Design and manage SQL Server database objects, including tables, views, stored procedures, and functions.
- Build data ingestion and transformation solutions using SSIS, Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure Synapse Analytics, and Databricks, with basic exposure to Databricks considered a plus.
- Create and manage Power BI datasets, dataflows, DAX measures, and interactive dashboards to support business reporting needs.
- Ensure data quality, reliability, and timely availability across various systems.
- Troubleshoot pipeline failures, performance bottlenecks, and data inconsistencies to maintain smooth operations.
- Collaborate closely with analysts and business users to gather and refine reporting requirements.
- Document workflows, data models, and standard operating procedures (SOPs) to maintain clear and accessible knowledge bases.

Required Qualifications

- 1 to 3 years of professional experience as a Data Engineer, BI Developer, or in a similar role.
- Strong proficiency in MS SQL Server and T-SQL for database development and optimization.
- Hands-on experience with Azure data tools such as Azure Data Factory, Azure Data Lake Storage, and Azure Synapse Analytics.
- Proficient in Power BI, including report creation, dashboard development, DAX formula writing, and data modeling.
- Solid understanding of ETL/ELT processes and data modeling concepts, including star and snowflake schemas.

Preferred Qualifications and Additional Information

- Basic exposure to Databricks is advantageous but not mandatory.
- The role requires working on-site, and candidates should be comfortable with the location near UCP.
- Candidates will be asked about their current and expected salary during the application process to ensure alignment.

This opportunity offers the chance to work in a dynamic environment where your contributions directly impact data-driven decision-making. If you are passionate about data engineering and eager to develop your skills in cloud-based technologies and business intelligence, we encourage you to apply.