Senior Power BI/Azure Associate
Location: New York, New York, United States
Department: RS
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.
Key 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.
Compensation:
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.
WHAT WE OFFER
- Career 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!
- Benefit Offerings: Medical, Dental, Vision, HCFSA, DCFSA, HSA, Commuter Transit and Parking, Supplemental Life Insurance, Accident Insurance, Critical Illness, Hospital Indemnity, Legal Program, Identify Theft Protection, Pet Discounts, Pet Insurance, Group Home and Auto Insurance, EAP, Short Term Disability, Life Insurance, Education Discounts, 401k w/ matching, Entertainment Discounts, & Paid Time Off.
- 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 SPS
SPS is an award-winning employer of choice offering outsourcing solutions that leverage Intelligent Automation (Artificial Intelligence & Robotic Process Automation) in more than 22 countries across the globe. In North America, our services include Mailroom Management (both physical and digital), Office Services such as Reception, Lobby Concierge and Conference Room Management in addition to Document Processing Services utilizing leading edge technologies. Our clients today are companies in sectors such as banking, insurance, legal, higher education, advertising and other professional services, including many Fortune 500 companies. SPS is committed to delivering high caliber outsourcing experience to our clients and offering our employees challenging and exciting career opportunities throughout the North America region and globally. SPS is committed to investing in the professional development of our employees and offers competitive comprehensive benefits and diverse development training programs that lead to building careers.
At SPS we embrace the uniqueness of our employees and are committed to the fair and equal treatment of all people, applicants, and employees by promoting a culture of access, inclusion, equity and diversity.
SPS provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, sexual and reproductive health choices, national origin, age, disability, genetics, military status, gender identity or expression, sexual orientation and/or any other status protected by applicable law.
Colorado only: We accept applications for an expected minimum of 5 days from the date it is posted. The posting may remain open longer as needed to ensure a robust and inclusive applicant pool.
Applicants are prohibited from using real-time AI (Artificial Intelligence) tools, prompts, scripts, or real-time assistance (including but not limited to chatbots, AI-generated responses, or transcription-based tools) during any and all interviews over any forum or platform.
SPS offers reasonable accommodations in the hiring and employment process for individuals with disabilities. If you need assistance in the application or hiring process to accommodate a disability, you may request an accommodation at any time.
To view our privacy policy, click on the link below: Data Privacy Statement
Acknowledgement Section: By submitting an application, by hitting "Submit Application", you certify that the information contained in this application is true and complete. You attest to the fact that the answers provided are correct to the best of your knowledge and ability. You certify that you have not knowingly withheld any information that might affect your chances for hiring. You understand that any false information or omission (including any misstatement) on this application or on any document used to secure this employment can be grounds for rejection of application or, if you are employed by SPS can be grounds for immediate termination from this company.
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say