Skip to main content
Back to jobs

Senior Power BI/Azure Associate

External
spsnorthamerica logoSpsnorthamerica · New York, NY
Full-timeOn-site2mo ago
AgileAzureComplianceData ModelingData WarehousingDocumentation
Cover LetterConnect

Prepare for this interview

Elite

AI-generated questions, company research, and talking points tailored to this role

Responsibilities

  • Data Integration & ETL
  • Develop and maintain robust data pipelines using Azure Data Factory (ADF) or Azure Synapse for ingestion, transformation, and loading across diverse data sources.
  • Implement orchestration frameworks, parameterized pipelines, and automated monitoring to ensure reliability, scalability, and performance.
  • Troubleshoot, optimize, and enhance ETL workflows aligned with enterprise data standards.
  • Data Modeling & Warehousing
  • Design and optimize data models using Azure Synapse Analytics or Azure Databricks to support analytical workloads and enterprise reporting.
  • Build star schemas, data lakehouse structures, and tune performance for large-scale datasets.
  • Partner with data architects to uphold data governance, lineage, and security compliance.
  • Reporting & Visualization
  • Develop dynamic, interactive dashboards and reports in Power BI that convert complex data into clear, actionable insights.
  • Build and maintain Power BI datasets, DAX measures, semantic models, and Row-Level Security (RLS).
  • Gather requirements and collaborate with business stakeholders to deliver intuitive, user-friendly visualizations.
  • Optimization & Automation
  • Monitor data workflows for performance bottlenecks, reliability risks, and cost optimization opportunities.
  • Automate recurring data processes to improve operational efficiency and data quality.
  • Implement quality controls and validation frameworks for consistent, accurate reporting.
  • Collaboration & Documentation
  • Work closely with Data Engineers, Analysts, and business partners to support enterprise analytics initiatives.
  • Produce detailed technical documentation, including pipeline configurations, data model designs, and dashboard specifications.
  • Contribute to best practices, standards, and continuous improvement efforts across the data organization.
  • Required Skills & Experience
  • 6-10 years of experience in data development, analytics, or related engineering roles.
  • Deep expertise in:
  • Microsoft Power BI (DAX, Power Query, data modeling, visualization best practices).
  • Azure Synapse Analytics (SQL, dedicated SQL pools, serverless query design).
  • Azure Data Factory (pipelines, linked services, dataflows, parameterization).
  • Strong command of SQL , enterprise data warehousing concepts, and ETL/ELT methodologies.
  • Hands-on experience with Azure Data Lake , Azure Blob Storage , or equivalent cloud storage platforms.
  • Strong analytical, diagnostic, and problem-resolution capabilities.
  • Ability to thrive in an agile, fast-paced environment, adapting quickly to evolving business needs.

Benefits

The expected compensation is an estimate, and the final offer will depend on skills, experience, and other job-related factors.Use of Artificial Intelligence (AI):No AI or automated decision-making tools are used to screen, assess, or select candidates for this role. SPS uses the Greenhouse applicant tracking system, which does not apply AI in these parts of the hiring process.Vacancy Status:This posting is for an existing vacancy.Pay Range$48 - $50 USDCareer Growth: An opportunity to enter a job that allows you to learn new skills or use a variety of them that may lead you to uncover other career opportunities!Learning & Development: At SPS, we promote a work culture of learning so that you can develop to be the best at what you do!We Recognize Talent: We offer a variety of recognition programs for all levels of employees!Note: Please inquire with the Human Resources team for benefit offerings per role as regular positions that routinely are under 30 hours/week may have a different benefit offering.About SPSDental insuranceVision insurance401(k)

Additional Information

Senior Power BI / Azure Associate Position Overview The Senior Power BI/Azure Associate plays a critical role in enabling enterprise-wide analytics by designing, developing, and optimizing data integration pipelines, data models, and reporting solutions. This role partners closely with business and technical teams to deliver scalable, high-quality data products that drive strategic decision-making.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at spsnorthamerica? Share your experience

Interested in this role?

Apply on the company's website.

Cover LetterConnect