Azure Synapse Analytics

Azure Synapse Analytics Engineer Jobs

10 jobs found

2d ago

Associate Data Engineer

Baker Tilly Advisory Group, LP Milwaukee, WI

Milwaukee, WI

2d ago

$86k - $163k/yr Full time Analytics Automation Azure Data Factory

Apply Now

Job Description

An Associate Data Engineer role at Baker Tilly Advisory Group, LP is based onsite in Milwaukee, WI, focusing on designing, building, and optimizing data solutions for mid-market and enterprise clients. You will work with Azure, Synapse, and Microsoft Fabric to transform raw data into analytics-ready assets that power dashboards, advanced analytics, and AI use cases. The position offers a competitive salary range of USD 85,910 to 162,890 per year and opportunities to collaborate with solution architects, analysts, and client stakeholders.

Responsibilities

Develop scalable, well-documented ETL/ELT pipelines using T-SQL, Python, Azure Data Factory or Fabric Data Pipelines, and Databricks; apply best-practice patterns for performance, security, and cost control.
Design relational and lakehouse models; implement Fabric OneLake shortcuts, medallion-style layers, and dimensional/semantic models for Power BI.
Build automated data-quality checks, lineage, and observability metrics; contribute to CI/CD workflows in Azure DevOps or GitHub.
Gather requirements, demo iterative deliverables, document technical designs, and translate complex concepts to non-technical audiences.
Research new capabilities, share findings in internal communities of practice, and contribute to reusable accelerators; collaborate with clients and internal stakeholders to design and implement scalable data engineering solutions.

Requirements

Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience).
2-3 years delivering production data solutions, preferably in a consulting or client-facing role.
Strong T-SQL for data transformation and performance tuning.
Python for data wrangling, orchestration, or notebook-based development.
Hands-on ETL/ELT with at least one Microsoft service (ADF, Synapse Pipelines, Fabric Data Pipelines).
Project experience with Microsoft Fabric (OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, Power BI DirectLake) preferred.
Familiarity with Databricks, Delta Lake, or comparable lakehouse technologies preferred.
Exposure to DevOps (YAML pipelines, Terraform/Bicep) and test automation frameworks preferred.
Experience integrating SaaS/ERP sources (e.g., Dynamics 365, Workday, Costpoint) preferred.

Technologies

T-SQL
Python
Azure Data Factory
Fabric Data Pipelines
Databricks
Fabric OneLake
Power BI
Azure DevOps
GitHub
Microsoft Fabric
Azure Synapse
Azure
Notebooks
Delta Lake
Dynamics 365
Workday
Costpoint
Terraform
Bicep
YAML pipelines
Power BI DirectLake

View full job page →

3d ago

Associate Data Engineer

Baker Tilly Advisory Group, LP Tampa, FL

Tampa, FL

3d ago

$86k - $163k/yr Full time Analytics Azure Azure Data Factory

Apply Now

Job Description

Associate Data Engineer role with Baker Tilly Advisory Group, LP in Tampa, FL (onsite), offering USD 85,910 - 162,890 per year.

Responsibilities

Data Engineering: Develop scalable ETL/ELT pipelines using T-SQL, Python, Azure Data Factory or Fabric Data Pipelines, and Databricks; implement patterns for performance, security, and cost control.
Modeling & Storage: Design relational and lakehouse data models; configure Fabric OneLake shortcuts, medallion style layers, and dimensional/semantic models for Power BI.
Quality & Governance: Build automated data quality checks, lineage, and observability metrics; contribute to CI/CD workflows in Azure DevOps or GitHub.
Client Delivery: Gather requirements, demonstrate iterative deliverables, document technical designs, and translate complex concepts for non-technical stakeholders.
Continuous Improvement: Research new capabilities, share findings in internal communities of practice, and contribute reusable accelerators; collaborate with clients and internal teams to design scalable data solutions.

Requirements

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).
2–3 years delivering production data solutions, preferably in a consulting or client-facing role.
Strong T-SQL for data transformation and performance tuning.
Python for data wrangling, orchestration, or notebook-based development.
Hands-on ETL/ELT with at least one Microsoft service (Azure Data Factory, Synapse Pipelines, Fabric Data Pipelines).
Project experience with Microsoft Fabric (OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, Power BI DirectLake) preferred.
Familiarity with Databricks, Delta Lake, or comparable lakehouse technologies preferred.
Exposure to DevOps (YAML pipelines, Terraform/Bicep) and test automation frameworks preferred.
Experience integrating SaaS/ERP sources (e.g., Dynamics 365, Workday, Costpoint) preferred.
Technologies you will work with: T-SQL, Python, Azure Data Factory, Fabric Data Pipelines, Databricks, Microsoft Fabric, OneLake, Lakehouses, Power BI, Delta Lake, Azure DevOps, GitHub, YAML pipelines, Terraform, Bicep, Dynamics 365, Workday, Costpoint.

View full job page →

3d ago

Data Engineer, Finance

ASCOT GROUP Iselin, NJ

Iselin, NJ

3d ago

$95k - $110k/yr Full time Azure Data Factory Azure Synapse Analytics Data

Apply Now

Job Description

Data Engineer, Finance role with ASCOT GROUP in Iselin, NJ, offering a hybrid work schedule and a focus on data warehouse projects.

Responsibilities

Operate as a Data Engineer Level 1 on projects, enhancements, and production support.
Own the analysis and provide hands-on development for assigned projects.
Contribute to work estimates by participating in feasibility, scoping, and estimation activities based on business requirements.
Assist in crafting high and low level designs and technical specifications ready for execution.
Validate the accuracy and quality of data integrations derived from ETL specifications and ensure data model specifications are met.
Engage in hands-on design, development, and testing for complex data related tasks.
Coordinate or lead production implementations to ensure smooth, high-quality releases.
Support the delivery of new warehouse sources, tables, marts, and related structures while following company standards.
Coordinate Ascot and vendor resources to secure timely, high-quality deliverables.
Think independently to streamline processes and eliminate inefficiencies.
Identify opportunities to accelerate speed and improve output quality; translate ideas into new capabilities and improvements.
Anticipate and report technical and organizational roadblocks.
Uphold The Ascot Way in daily interactions, promoting collaboration, inclusion, and accountability.

Requirements

Bachelor’s degree in information systems, Computer Science, Data Analytics, or a related field, or equivalent experience.
2+ years of experience as a Data Analyst/Engineer for a large Data Warehouse handling sizable data sets.
Experience with ETL tools such as SSIS, Informatica, or ADF.
Industry experience in Commercial and/or Specialty insurance is preferred.
Understanding of financial data and related concepts.
Analytical mindset with strong attention to detail.
Proven SQL skills and experience using SQL to identify and correct data issues.
Database knowledge, preferably SQL Server and/or Synapse.
Scripting and SQL proficiency to perform ETL, data/file validation, analysis, and profiling.
Basic ability to create, read, understand, and interpret Data Models.
Code maintenance and review experience in one or more general purpose programming languages.
Understanding of insurance domain data models is desirable.

Technologies

Phinsys
Data & Integration Hub
SQL
SSIS
Informatica
ADF
SQL Server
Synapse

Benefits

Health and welfare benefits
Leave benefits
Retirement benefits

Position Overview

The Data Engineer in the Data Integration & Delivery Team is responsible for the analysis, development, implementation, testing, and ongoing support of data warehouse projects, including Phinsys and the Data & Integration Hub. This role is based in the office with a hybrid work schedule in Iselin, NJ.

View full job page →

6d ago

Data Engineer (Warehouse, BI & SQL DBA)

Barrett-Jackson Auction Co, LLC Scottsdale, AZ

Scottsdale, AZ

6d ago

Full time Analytics Azure Azure Data Factory

Apply Now

Job Description

The Data Engineer role at Barrett-Jackson Auction Co, LLC is based onsite in Scottsdale, AZ. The position focuses on end-to-end Microsoft data platform design, administration, ELT/ETL development, and governance for a warehouse and lakehouse environment on Azure Synapse and/or Microsoft Fabric, enabling analytics and Power BI reporting for the local IT team.

Responsibilities

Plan, build, and operate SQL Server and Azure SQL databases, covering schema design, indexing strategies, constraints, and data integrity controls.
Manage core DBA functions including backup and restore, high availability and disaster recovery, patching and upgrades, capacity planning, monitoring, alerts, and routine maintenance.
Develop and optimize ELT/ETL pipelines using Microsoft tooling such as Azure Data Factory, Synapse Pipelines, or Fabric Data Factory to integrate data from on‑premises and cloud sources.
Create scalable transformation patterns with T-SQL and Spark where applicable, establishing repeatable, testable data processing frameworks.
Design and govern the enterprise Data Warehouse and Lakehouse, implementing dimensional modeling (star/snowflake), incremental loads, historization (SCD), and alignment of the semantic layer for BI.
Administer and optimize Azure Synapse and/or Microsoft Fabric components, including workspace organization, resource governance, and performance and cost tuning.
Enable Power BI reporting by delivering curated datasets, developing semantic models, and collaborating with analysts on performance, refresh strategies, and best practices.
Implement data quality, reconciliation, and observability through logging, lineage, and SLAs; drive root-cause analysis for data issues across pipelines and reporting.
Establish and enforce security and governance controls such as RBAC, least privilege, encryption, PII handling, and auditability across databases, lakehouse/warehouse, and BI layers.
Automate deployments and operations with Git-based workflows and CI/CD, leveraging Azure DevOps or GitHub, and applying infrastructure-as-code where appropriate.
Create comprehensive technical documentation for data models, source-to-target mappings, runbooks, and support procedures.
Collaborate with application engineering, product, and business stakeholders to translate requirements into reliable data products and deliver iteratively in an Agile environment.

Requirements

6+ years of hands-on experience in data engineering and/or data warehouse engineering, including production-grade pipelines and curated datasets.
4+ years administering and tuning SQL Server and/or Azure SQL, including query optimization, indexing, security, backup/restore, and maintenance.
Strong proficiency in T-SQL, relational data modeling, and performance tuning (execution plans, statistics, partitioning, and concurrency patterns).
Experience building ELT/ETL with Azure Data Factory, Synapse Pipelines, and/or Fabric Data Factory; familiarity with event- or file-based ingestion patterns.
Experience designing and operating a modern warehouse or lakehouse using Azure Synapse and/or Microsoft Fabric (Lakehouse/Warehouse, notebooks/Spark, and orchestration).
Solid understanding of data warehouse concepts and modeling techniques (Kimball dimensional modeling, SCD, data marts, and semantic layer alignment).
Power BI experience supporting enterprise reporting, including datasets, semantic models, refresh strategies, performance optimization, and workspace governance.
Experience with Azure security and identity patterns (Azure AD, managed identities, Key Vault, RBAC) and protecting sensitive data (PII) end-to-end.
Hands-on experience with DevOps practices: Git branching, code reviews, CI/CD, and automated deployments (Azure DevOps and/or GitHub).
Strong troubleshooting skills across data pipelines, databases, and BI; able to communicate clearly with technical and non-technical stakeholders.
Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent experience.

Technologies

SQL Server, Azure SQL
Azure Data Factory, Synapse Pipelines, Fabric Data Factory
Spark, T-SQL
Azure Synapse, Microsoft Fabric
Power BI
Azure AD, Key Vault, RBAC
Azure DevOps, GitHub

Culture

The Barrett-Jackson culture is in-person and collaborative, with employees working onsite at the Scottsdale headquarters five days a week from 8 am to 5 pm. When live events occur, the team often travels together to ensure event success, which may involve weekend work and extended hours. The environment is described as energetic and engaging, with a strong sense of purpose around each event.

View full job page →

7d ago

Data Analyst, Technology Consulting - Data & Analytics (Data Architecture & Engineering) - Financial Services Office (Manager)

EY Philadelphia, PA

Philadelphia, PA

7d ago

$218k - $218k/yr Full time Manager Analytics Azure Synapse Analytics

Apply Now

Job Description

EY's Financial Services Office in Philadelphia is seeking a Data Analyst in Technology Consulting focused on Data & Analytics, with emphasis on Data Architecture & Engineering. This hybrid role centers on designing modern data platforms and data products to support end-to-end data solutions for financial services clients, and includes leadership responsibilities within the Philadelphia team. The position offers a compensation of USD 218,230 per year.

Below is a structured summary of responsibilities, requirements, technologies and benefits associated with the role.

Responsibilities

Understand business challenges and address remediation through data architecture and engineering solutions.
Collaborate with clients to transform data usage by architecting modern data platforms, data products, and data marketplaces, delivering end-to-end solutions that improve the data supply chain, reengineer processes, enhance risk controls, and enable information intelligence using current technologies.
Solve complex issues and drive growth across the financial services sector.
Define data and analytic strategies by conducting assessments, recommending remediation strategies based on identified gaps, and designing future-state data and analytics solutions.
Lead and coach diverse teams with varied backgrounds; manage cross-functional teams to ensure task and timeline accountability.
Propose and drive new technologies to enhance or replace existing business processes.
Initiate and build thought leadership through white papers, points of view, and proofs of concept.
Develop strategies to solve problems logically using creative methods.
Engage and influence large teams and functional leaders; maintain long-term client relationships and networks; cultivate business development opportunities.

Requirements

Bachelor's degree in Engineering, Computer Science, Business, Economics, Finance, Statistics, Analytics or related field with 5 years of progressive, post-baccalaureate work experience; or Master’s degree in the same fields with 4 years of related work experience.
3 years of combined experience in the banking, capital markets, insurance, and/or wealth and asset management industries.
3 years of experience assisting clients with strategic Data Architecture and Engineering, Cloud Data Modernization, Data Products, Data Mesh, Data Fabric, Big Data initiatives and/or Event-driven Architecture.
3 years of experience with traditional data architecture practices including Master Data Management, Operational Data Analytics, Customer Data Hub, and/or Data Warehousing.
3 years of experience with Next-Gen platforms including hyperscalers (AWS, GCP, and/or Azure), Snowflake, Databricks, and/or distributed databases.
3 years of experience designing or architecting large data platforms, data warehouses, streaming applications, data ingestion pipelines, data storage patterns, and/or data integration pipelines.
3 years of combined experience in at least one of: traditional RDBMS (MS SQL Server, Oracle, MySQL, PostgreSQL); MPP (Redshift, Synapse, Teradata, Vertica, Netezza); NoSQL (MongoDB, DynamoDB, Cassandra, Neo4J, Titan, Elasticsearch); Streaming Platform and Applications (Spark streaming, Kafka, Confluent, Storm); DevOps (GitHub, Kubernetes, Jenkins, Terraform); Data Modeling (Data Vault, Star, Snowflake, or Canonical).
Domestic and regional travel up to 60% to meet client needs.

Technologies

AWS, GCP, Azure
Snowflake, Databricks, Redshift, Synapse, Teradata, Vertica, Netezza
MongoDB, DynamoDB, Cassandra, Neo4j, Titan, Elasticsearch
Spark streaming, Kafka, Confluent, Storm
GitHub, Kubernetes, Jenkins, Terraform
MS SQL Server, Oracle, MySQL, PostgreSQL
Data Vault, Star, Canonical
Master Data Management

Benefits

Medical and dental coverage
Pension and 401(k) plans
Paid time off
Hybrid work model
Flexible vacation policy
EY paid holidays
Winter/Summer breaks
Personal/Family care
Other leaves of absence
Continuous learning
Transformative leadership
Diverse and inclusive culture

View full job page →

8d ago

Senior Data Analytics Engineer

Core BTS Remote 🌍 Remote

Remote

8d ago

$97k - $130k/yr Full time Senior Analytics Azure Data Factory

Apply Now

Job Description

Senior Data Analytics Engineer on Core BTS's Data Analytics Data Platform (DADP) team, remotely located with a salary range of USD 97,000 to 130,000 per year, focused on delivering BI solutions and scalable data platforms using the Microsoft Analytics stack.

Responsibilities

Demonstrates passion, excellence, trust, transparency, and client focus.
Builds and maintains databases, data pipelines, and data lakes.
Transforms and models data, develops reporting and analytics, creates dashboards, and leverages analytics tools.
Understands business problems and processes through direct client conversations, sees the big picture, and translates that into concrete solutions.
Collaborates with other DADP team members across all stages of the data analytics lifecycle—from requirements gathering and solution delivery to documenting lessons learned.
Addresses conflicts directly, maintains positive intent, and seeks guidance from leaders when needed.
Adapts positively to change by adopting new practices and processes.
Maintains a positive, professional, and self-confident presence in interactions.
Responds to clients in a timely and professional manner.
Seeks to consistently meet or exceed client expectations and collaborates to address their business needs.
Communicates accurately, concisely, and effectively with stakeholders.
Listens respectfully to others' ideas and concerns with an open mind.
Develops and maintains effective working relationships with colleagues.
Collaborates to solve problems and prioritizes team success.
Meets commitments and delivers work on schedule.
Holds self and others accountable for responsibilities and outcomes.
Acts with ownership, accepting responsibility for decisions and actions.
Works independently or as part of a team of technical professionals.
Balances multiple projects while remaining attentive to end users, clients, and project managers.
Provides top-notch service and recommendations to clients, the project team, and the broader NRI team.

Requirements

3-5 years of work experience in data engineering.
Experience with Azure Data Factory.
Experience with Azure Databricks.
Experience with Azure Synapse.
Experience with Fabric.
Understanding of Agile engineering practices.
Data warehouse and lakehouse methodologies, including medallion architecture.
Data ETL/ELT processes.
Data profiling and anomaly detection.
Data modeling (Dimensional/Kimball).
SQL proficiency.
Strong background in relational database platforms.
DevOps / Continuous Integration and Continuous Delivery.
Growing familiarity and experience with Python.
Excellent analytical and problem-solving skills.
Effective oral and written communication and organizational skills.
Desire for continued education and certification relevant to the position.
Previous consulting experience is preferred but not required.

Technologies

Microsoft Analytics stack
Azure Data Factory
Azure Databricks
Azure Synapse
Fabric
SQL
Python

Benefits

Health, Vision, and Dental Insurance
Life Insurance
Health/Dependent Care Flexible Spending
401(k) Plan
Short-Term and Long-Term Disability Coverage
Generous Vacation and Flex Time Off Programs
Company Paid Holidays
Training and Development Opportunities

Notices

The above description is intended to describe the general nature and level of work performed by individuals assigned to this position. This is not an exhaustive list of all responsibilities, duties, knowledge, skills, or experience required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential duties.
NRI North America is proud to be an Equal Opportunity/Affirmative Action employer.
NRI North America will accept applications on an ongoing basis.
NRI North America will consider qualified candidates with criminal histories in a manner consistent with The Los Angeles Fair Chance Initiative for Hiring Ordinance.
If you require reasonable accommodation in completing an application, interviewing, or otherwise participating in the hiring process, please direct inquiries to [email protected].

View full job page →

12d ago

Sr. Data & Analytics Engineer

Applix Inc. Nashville, TN

Nashville, TN

12d ago

$70k - $110k/yr Full time Senior Analytics Azure

Apply Now

Job Description

Senior Data & Analytics Engineer specializing in Microsoft Fabric (COE) for a full-time, on-site role with a Fortune 100 enterprise in Nashville, TN. This position centers on enabling enterprise-wide adoption of Microsoft Fabric and modern analytics practices, partnering with business units to design scalable data architectures, and migrating legacy analytics to Fabric while shaping Lakehouse architectures, semantic models, and governance.

Summary

The Senior Data & Analytics Engineer focuses on driving Fabric adoption across the organization within a centralized COE, ensuring high standards for performance, reliability, and data quality across the analytics landscape. The role emphasizes collaboration with business units and engineering teams to create scalable assets and migrate legacy environments to Fabric, rather than building isolated dashboards.

Responsibilities

Operate within a centralized BI and Intelligent Automation COE to champion enterprise wide adoption of Microsoft Fabric and contemporary analytics practices.
Partner with business units and engineering teams to design scalable data architectures, develop reusable assets, and guide the migration of legacy analytics environments to Fabric.
Contribute to shaping Lakehouse architectures, semantic models, and governance frameworks while ensuring performance, reliability, and data quality across the analytics ecosystem.

Requirements

Proven experience in data engineering, data modeling, and modern analytics platforms.
Hands-on expertise with Microsoft Fabric, including Lakehouse, Data Factory pipelines, Dataflows Gen2, and notebooks.
Advanced Power BI skills, covering semantic modeling, DAX, performance tuning, and workspace design.
Strong understanding of ETL/ELT processes, medallion architecture Bronze/Silver/Gold, and SQL-based transformations.
Experience building scalable data pipelines, reusable data assets, and governed analytics environments.
Solid troubleshooting capabilities across data pipelines, BI tools, and distributed data systems.
Proficiency in scripting or automation using Python, PowerShell, or SQL.
Ability to collaborate with cross-functional teams and communicate effectively with technical and business stakeholders.
Experience in enterprise COE or platform enablement roles is a strong plus.
Familiarity with Azure data services, CI/CD practices, and BI platform governance is preferred.
Education: Bachelor's or Master’s degree in Computer Science, Data Engineering, or a related field.

Technologies

Microsoft Fabric
Lakehouse
Data Factory
Dataflows Gen2
Notebooks
Power BI
DAX
SQL
Python
PowerShell
Azure Data Lake Storage (ADLS)
Azure Synapse Analytics
Azure SQL
Medallion architecture (Bronze/Silver/Gold)

Benefits

401(k)
Dental insurance
Health insurance
Vision insurance

Role Description

The position is a full-time, on-site Senior Data & Analytics Engineer for a Fortune 100 enterprise located in Nashville, Tennessee. It resides within a centralized BI and Intelligent Automation COE and centers on enabling enterprise-wide adoption of Microsoft Fabric and modern analytics practices. The incumbent will collaborate with business units and engineering teams to design scalable data architectures, develop reusable assets, and guide the migration of legacy analytics to Fabric, while shaping Lakehouse architectures, semantic models, and governance frameworks to ensure high performance and data quality across the analytics ecosystem.

Pay

USD 70,000.00 – 110,000.00 per year.

Application Questions

Are you a green card holder or a US citizen?
Total years of experience in data engineering or analytics?
Years of experience with Power BI?
Are you willing to work on-site in Nashville, TN, or Dallas, TX, or Peoria, IL?
Years of experience with Delta tables or Lakehouse architectures?
Rate your DAX proficiency on a scale from 1 to 10.
Years of experience with SQL for data transformation and analysis?
Years of experience with Azure data services (ADLS, Synapse, Azure SQL, etc.)?
Have you built or supported a Fabric Lakehouse environment?
Have you created Data Factory pipelines in Fabric?
Have you worked with Dataflows Gen2?
Have you implemented medallion architecture (Bronze/Silver/Gold)?
Have you built and optimized Power BI semantic models at scale?
Have you performed Power BI performance tuning (dataset optimization, query reduction, etc.)?
Do you have experience with Python, PowerShell, or scripting for automation?