Senior Data Engineer
Stoneridge Software
full-time
Posted on:
Location Type: Remote
Location: Remote • Minnesota • 🇺🇸 United States
Visit company websiteSalary
💰 $171,900 - $216,400 per year
Job Level
Senior
Tech Stack
AzureETLPySparkPythonSQL
About the role
- Drive data engineering work across project phases, including discovery, design, build, test, deploy, and ongoing improvement
- Lead discussions with clients and internal stakeholders regarding data ingestion, integration approaches, and architecture decisions
- Design and build scalable data pipelines using Microsoft Fabric (lakehouses, warehouses, pipelines, dataflows, notebooks)
- Extract and integrate data from Dynamics 365 applications (F&O, Customer Engagement, Sales), Dataverse, and external systems
- Cleanse, model, and transform raw data to support analytics, reporting, semantic modeling, and governance needs
- Create, maintain, and optimize semantic models and DAX calculations for business-ready reporting
- Monitor and optimize pipeline and storage performance (latency, cost, resource consumption)
- Conduct root‑cause analysis for complex pipeline or data quality issues and lead resolution efforts
- Review code, provide recommendations, and drive best practices across the engineering team
- Ensure data governance, privacy, security, and quality standards are met—including lineage, access control, and monitoring
- Collaborate cross‑functionally to translate business requirements into scalable technical designs
- Develop internal standards, frameworks, and reusable components to improve efficiency and consistency
- Mentor other engineers and contribute to a culture that values integrity, continuous learning, resilience, and joy in our work
- Influences design decisions across engineering, architecture, and analytics teams
Requirements
- Bachelor’s degree in Computer Science, Information Systems, or related field; or equivalent work experience
- 5+ years of experience with Dynamics 365 data models, APIs, Dataverse, and data entities
- 5+ years of experience with ETL pipelines and Azure data services (Azure Data Lake, Azure Synapse, Azure Data Factory)
- Experience with Microsoft Fabric (lakehouses, warehouses, pipelines, semantic models, notebooks)
- Strong SQL skills and familiarity with Python or PySpark
- Experience with CI/CD, Git version control, monitoring, and observability for data pipelines
- Knowledge of Power BI—including reports, dashboards, DAX, and data modeling
- Strong understanding of data governance, security, privacy, and access control
- Ability to design scalable data architectures and reusable ingestion and transformation frameworks
- Strong business acumen and ability to translate business needs into technical solutions
- Excellent communication, documentation, problem‑solving, and organizational skills
- Microsoft certifications (e.g., DP‑600 Fabric Analytics Engineer, Azure Data Engineer) are a plus
- Displays a growth mindset and passion for continuous learning, and commitment to delivering high-quality work on time
- Shows a positive, team‑oriented approach to change, feedback, and innovation
- Ability to communicate effectively in both spoken and written English
- Exhibits Stoneridge Software’s Core Values of Integrity, Technical Excellence, Tenacity, Client Centric, and Enjoy your Work
Benefits
- Medical Insurance
- Dental Insurance
- Vision insurance
- 401(k) contribution program (US) or RRSP Benefits (Canada)
- Life insurance
- Disability Benefits
- Paid parental leave
- Paid flexible time off
- Paid sick time (US) or floater days (Canada)
- Paid holidays
- Flexible work schedules
- Mobile/internet reimbursement
- Employee and family assistance program
- Learning and development funding
- Employer charitable contribution
- Paid business mileage
- Home office and wellness allowance (US Only)
- HSA contribution (US Only)
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data engineeringdata ingestiondata integrationdata pipelinesETL pipelinesSQLPythonPySparkDAXdata modeling
Soft skills
communicationproblem-solvingorganizational skillsmentoringcollaborationbusiness acumengrowth mindsetteam-orientedcontinuous learningintegrity
Certifications
DP-600 Fabric Analytics EngineerAzure Data Engineer