Azure Synapse Analytics

Azure Synapse Analytics Finance Jobs

3 jobs found

1mo ago

Senior Data Analyst - Finance

M. A. Mortenson Company Minneapolis, MN

Minneapolis, MN

1mo ago Closed

$96k - $145k/yr Full time Senior Analyst Analytics

This position is no longer accepting applications (closed Aug 6, 2026).

Job Description

In Minneapolis, the role operates within a hybrid work framework, supporting Finance reporting and analytics by engineering trusted datasets and semantic models in Microsoft Fabric and Power BI. This position collaborates with Finance leaders, data consumers, and cross-functional teams to translate business questions into governed metrics, performant models, and self-serve visuals that drive informed decision making.

Responsibilities

Facilitate cross-functional conversations in a collaborative, team-based setting to capture reporting needs.
Design and develop intuitive Power BI reports and dashboards that empower Finance leadership and teams to make informed decisions.
Translate requirements into effective visuals, tooltips, drill paths, and narrative elements that highlight key drivers and exceptions.
Apply visualization standards for layout and KPI definitions, and optimize report performance through model usage and visuals tuning.
Design, build, and maintain Fabric/Power BI semantic models (star schemas, relationships, calculation groups) to enable consistent, trusted reporting.
Engineer reusable DAX measures and KPI definitions; document metric logic to align with Finance definitions and standards.
Develop reliable data shaping pipelines (SQL, Power Query, Dataflows Gen2) with reconciliations to validate completeness and accuracy.
Manage Fabric/Power BI workspaces, semantic models, and refresh processes in coordination with BI platform administrators.
Adopt CI/CD practices, contribute to release and validation processes, and pursue improvements to deployment workflows.
Monitor model and report performance, refresh reliability, and scalability; troubleshoot issues with durable, sustainable fixes.
Implement security patterns (RLS/OLS), access controls, and governance-aligned practices for Finance reporting solutions.
Collaborate with stakeholders to understand reporting requirements and provide training, documentation, and guidance.
Serve as a trusted resource for ongoing reporting and analytics requests, applying advanced analysis and problem-solving skills.
Contribute to long-term BI and data strategy; identify automation opportunities and support modernization efforts.
Maintain processes to consolidate large data volumes into centralized, repeatable measurements; review finance data and propose corrective actions as needed.
Stay current with Microsoft tooling and data operations best practices; track Data Quality and Data Governance KPIs for Finance.
Provide peer support and informal mentoring; identify and pursue strategic initiatives.

Requirements

Bachelor’s degree with 3-5 years of related experience; or a high school diploma/GED with 8+ years of related experience.
3-6 years delivering Power BI solutions, including semantic modeling and end-user reporting.
Strong command of Power BI (Desktop/Service) and Microsoft Fabric concepts (semantic models, workspaces, refresh, security).
Advanced experience with SQL Server, T-SQL, or database design.
Advanced knowledge of DAX and Power Query (M).
Proven experience with dimensional modeling (star schemas), semantic model design, and performance tuning for self-service analytics.
Ability to translate business questions into actionable BI solutions.
Familiarity with Fabric/Azure data services (Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, Data Factory/Synapse as applicable).
Excellent attention to detail with a professional, customer-service oriented mindset.
Strong communication skills and the ability to present data clearly.
Ability to assess, prioritize, and manage multiple stakeholder needs while delivering high-quality work on time.
Experience with Agile product delivery and sprint planning.
Nice-to-have: knowledge of Python or R for analytics and data transformations.
Nice-to-have: experience using Git or other version control systems.
Nice-to-have: Microsoft BI or data engineering certifications.

Technologies

Microsoft Fabric, Power BI, DAX, Power Query (M)
SQL Server, T-SQL
Dataflows Gen2, Git, Python, R
Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, Data Factory, Synapse

Benefits

Medical and prescription drug plans with no additional cost vision coverage
Dental plan
401(k) with a generous Mortenson match
Paid time off, holidays, and other paid leaves
Employer-paid Life, AD&D, and disability insurance
No-cost mental health resources and work-life concierge services
Tuition reimbursement
Adoption assistance
Gym membership discount program

Compensation

Salary range: USD 96,400 - 144,700 per year.

Other items to note

Mortenson reserves the right to hire any individual without reliance on solicitations; no agency emails, calls, or solicitations are accepted without a valid agreement.
Candidates must be legally authorized to work in the United States without sponsorship for employment visa status at this time.

View full job page →

2mo ago

Data Engineer, Finance

ASCOT GROUP Iselin, NJ

Iselin, NJ

2mo ago Closed

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

This position is no longer accepting applications (closed Jul 2, 2026).

Job Description

Ascot Group’s Data Integration & Delivery Team is seeking a Data Engineer to design, build, test, and support data warehouse initiatives. The role centers on Phinsys and the Data & Integration Hub, with a hybrid in-office schedule in Iselin, NJ and a salary range of USD 95,000 to 110,000 per year. A bachelor’s degree and at least two years of relevant experience are required.

Position Overview

Based in Iselin, NJ with a hybrid work arrangement, the Data Engineer will contribute to analysis, development, implementation, testing, and ongoing support of data warehouse projects, including Phinsys and the Data & Integration Hub. The compensation range for this role is USD 95,000 to 110,000 annually, and a Bachelor's degree is required.

Responsibilities

Serve as a Data Engineer Level 1 for projects, enhancements, and production support.
Be responsible for all analysis and support of assigned projects to include hands-on development.
Assist in establishing work estimates based on business requirements through participation in project feasibility, scoping, and estimating activities.
Assist in the high/low level designs and technical specifications that can be accurately executed.
Validate accuracy/quality of data integrations generated from ETL specifications. Ensure data model specifications are met.
Assist with hands-on design, development and testing for the most complex data related work.
Coordinate/lead production implementations to ensure smooth, quality releases.
Participate in the delivery of new warehouse sources/tables/mart etc. while leveraging existing company standards.
Coordinate Ascot and Vendor resources to ensure high quality and timely deliverables.
Think independently and creatively to streamline work and root out inefficiencies.
Find opportunities to increase speed and quality of output. Must be able to articulate ideas and turn those ideas into new capabilities, performance improvements, and quality improvements.
Anticipate and report technical and organizational roadblocks.
Commitment to The Ascot Way: Embody The Ascot Way in daily interactions, fostering colleague engagement, collaboration, inclusivity, 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 working with large data sets.
Some ETL Tool experience; SSIS, Informatica, ADF
Some experience in the Commercial and/or Specialty insurance industry is desired.
An understanding of financial data and concepts.
Analytical, rigorous, with attention to detail.
Proven SQL skills
Proven experience using SQL to identify and correct data issues.
Some Database knowledge, preferably SQL Server, Synapse
Capable scripting/SQL skills to perform ETL, data/file validation, analysis, and profiling.
Minimal ability to create, read, understand, and interpret Data Models
Code maintenance and review experience in one or more general purpose languages.
Understanding insurance domain data models, desired

Technologies

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

Benefits

Health and welfare benefits
Leave benefits
Retirement benefits

View full job page →

2mo ago

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

EY Philadelphia, PA

Philadelphia, PA

2mo ago Closed

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

This position is no longer accepting applications (closed Jun 28, 2026).

Job Description

EY's Financial Services Office in Philadelphia is seeking a Data Analyst within Technology Consulting to shape data architecture and engineering for financial services clients. The role combines hands-on design of modern data platforms and data products with leadership across cross-functional teams, delivering end-to-end data solutions from concept through delivery in a hybrid work setting.

Location: Philadelphia, PA (hybrid)

Salary: USD 218,230 per year

Responsibilities

Assess business challenges and translate them into data architecture and engineering remediations.
Partner with clients to transform how they use and govern data by designing modern data platforms, data products, and data marketplaces, delivering end-to-end solutions that enhance data supply chains, reengineer processes, strengthen risk controls, and enable information intelligence using advanced technologies.
Resolve complex issues and drive growth initiatives across the financial services sector.
Define data and analytics strategies by conducting assessments, recommending remediation approaches, and designing future-state solutions.
Lead and coach diverse teams with varied professional backgrounds.
Coordinate cross-functional teams to ensure accountability for project tasks and timelines.
Propose and champion new technologies to improve or replace existing business processes.
Develop thought leadership through white papers, point of views, and proofs of concept.
Devise problem-solving strategies that combine logical and creative approaches.
Engage and influence large teams and functional leaders to achieve outcomes.
Maintain long-term client relationships and professional networks.
Cultivate opportunities for business development.

Requirements

Bachelor’s degree in Engineering, Computer Science, Business, Economics, Finance, Statistics, Analytics or related field plus 5 years of progressive work experience; or a Master’s degree with 4 years of related experience.
At least 3 years of combined experience in banking, capital markets, insurance, and/or wealth and asset management.
Minimum 3 years assisting clients with strategic Data Architecture and Engineering, Cloud Data Modernization, Data Products, Data Mesh, Data Fabric, Big Data initiatives, or Event-driven Architecture.
Minimum 3 years in traditional data architecture practices including Master Data Management, Operational Data Analytics, Customer Data Hub, and/or Data Warehousing.
Minimum 3 years working with Next-Gen platforms such as AWS, GCP, Azure, Snowflake, Databricks, and/or distributed databases.
Minimum 3 years designing large data platforms, data warehouses, streaming applications, data ingestion pipelines, data storage patterns, and/or data integration pipelines.
Minimum 3 years 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 (Spark streaming, Kafka, Confluent, Storm); DevOps (GitHub, Kubernetes, Jenkins, Terraform); or Data Modeling (Data Vault, Star, Snowflake, 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 and Summer breaks
Personal and family care
Other leaves of absence
Continuous learning
Transformative leadership
Diverse and inclusive culture

View full job page →

Azure Synapse Analytics Finance Jobs

Senior Data Analyst - Finance

Data Engineer, Finance

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

Get Azure Synapse Analytics Finance Jobs alerts