Senior Data Scientist - Solution Architect

Lever, Inc.; United States; Remote; USD 160,000 - 220,000; Full time

Benefits offered by this job

Work/Life Balance with UP TO PTO

401k Plan with Company Matching

Home Office Stipend

Medical, Dental and Vision Coverage

Health Savings and Flexible Spending

Job summary

MCA Connect is seeking a Senior Data Science Engineer who can bridge data science, data engineering, and software development in a Microsoft-centric stack. You will drive data-driven decision making, build scalable pipelines in Azure, and deliver insights with Power BI, Fabric, and Databricks.

Expect ownership of deployed workloads, collaboration with manufacturing clients, and a strong emphasis on validation, reproducibility, and cost-aware architecture.

Qualifications

• 5+ years of relevant professional experience in data science, data engineering, or software engineering.
• 3+ years building, deploying, and supporting workloads in Microsoft Azure.
• Bachelor's degree in a related field; master's a plus but not required.
• Ability to own deployed solutions and troubleshoot operational issues.
• Experience with data storage, compute, and cost management in Azure.
• Strong Python and SQL development and MS Fabric/Azure Databricks proficiency.
• Experience building reports and semantic models in Power BI.
• Familiarity with AI tooling and validation of results.

Responsibilities

• Translate business questions into measurable analytical problems with explicit criteria.
• Develop, deploy, and monitor end-to-end data science workloads in Azure.
• Build reusable data processing components and maintainable codebases.
• Collaborate with stakeholders to validate models and integrate results.
• Ensure data lineage, access controls, and security across platforms.
• Design reproducible experiments and robust tests for models.
• Provide clear explanations of methods, tradeoffs, and limitations.

Skills

Python

SQL

Azure

Power BI

Data modeling

Data engineering

Problem solving

Communication

Education

Bachelor's degree in operations research, business, computer science, data science, information systems, statistics, mathematics, engineering, or related field

Tools

Azure Databricks

Microsoft Fabric

PySpark

Delta Lake

Power Query

DAX

GitHub Actions

Job description

Through passion and deep industry expertise, MCA Connect helps manufacturers succeed by unlocking innovation with actionable business insights. Our strategic solutions, innovation, and industry intelligence help manufacturers gain visibility, improve profitability, and achieve a competitive edge.

Established in 2002, MCA Connect has grown into one of the largest US-based solution partners in Microsoft Business Applications and Azure Data & AI / Digital & App Innovation. Our Microsoft Specialties include Finance and Supply Chain, Analytics on Azure, Data Warehouse Migration, and Power Platform. We’re also a fifteen-time Microsoft Partner of the Year and three-time Inc. Best Workplaces award winner.

Senior Data Science Engineer

Planning and Decision Systems

Location

Remote with light travel as needed to client sites

Employment Type

Full-time

We are seeking a Senior Data Science Engineer with strong Python and SQL skills, quantitative judgment, and demonstrated strength in Azure. The role combines data science, data engineering, and software development. Practical working proficiency in Power BI, Microsoft Fabric, and Azure Databricks is required, alongside effective use of AI development tools and independent validation of results.

Experience and education

At least 5 years of relevant professional experience in data science, data engineering, or software engineering, including at least 3 years building, deploying, and supporting workloads in Microsoft Azure. Candidates should demonstrate ownership of deployed solutions and the ability to troubleshoot operational issues.

A bachelor's degree in operations research, business, computer science, data science, information systems, statistics, mathematics, engineering, or a related field, or equivalent demonstrated professional experience. A master's degree is a plus but is not required. A PhD is not required.

Required platform and technical skills

• Microsoft Azure: Strong hands-on capability in data storage and compute, identity and access, secure connectivity, deployment automation, monitoring, troubleshooting, and cost management. Relevant services include ADLS Gen2, Azure SQL, Entra ID, managed identities, Key Vault, and Azure Monitor.
• Power BI: Working proficiency building reports and semantic models, using Power Query and DAX, defining relationships and measures, configuring refresh and row-level security, and reconciling reported metrics to source data.
• Microsoft Fabric: Practical experience with workspaces, OneLake, lakehouses or warehouses, and data pipelines or notebooks. Ability to follow data lineage, manage appropriate access, and diagnose processing or reporting issues.
• Azure Databricks: Working proficiency with notebooks, PySpark or Spark SQL, Delta Lake tables, and scheduled jobs. Ability to investigate failed runs and understand compute configuration, data permissions, and performance tradeoffs.
• Python and SQL: Strong proficiency in data preparation, analysis, reusable components, and backend processing. Ability to read unfamiliar code, explain its behavior, and improve its maintainability.
• Data modeling and integration: Understand analytical data models, schemas, data grain, join cardinality, missing values, time alignment, and traceability across data sources and reports.
• Software delivery: Apply version control, code review, automated testing, and controlled releases. Understand APIs, persistent state, long-running processing, and safe recovery from failures.

AI assisted development

Demonstrate agentic development capability with tools such as Claude Code and OpenAI Codex. Break work into bounded tasks, provide repository context and constraints, direct coding agents, and iterate through implementation, testing, and debugging. Review generated changes, manage branches and tool permissions, protect sensitive information, and independently verify code and analytical results before release.

Analytical and problem solving skills

• Translate ambiguous business questions into measurable analytical problems, with explicit assumptions, objectives, constraints, and success criteria.
• Apply statistical and mathematical reasoning, including weighted metrics, uncertainty, validation design, data leakage, and the distinction between association and causation.
• Assess data completeness, consistency, and suitability before choosing analytical methods. Reconcile inputs, intermediate calculations, and reported outputs.
• Evaluate models and analytical results against meaningful baselines. Distinguish improved model performance from changes in data selection, aggregation, or assumptions.
• Reproduce unexpected behavior, construct small diagnostic examples, and use evidence to distinguish data, modeling, and implementation problems.
• Design reproducible experiments and regression and integration tests. Verify behavior across processing, storage, APIs, and reporting boundaries.
• Diagnose performance and usability issues involving large datasets, long-running tasks, stale results, and failure reporting.
• Explain methods, tradeoffs, uncertainty, and limitations clearly to technical and nontechnical stakeholders.

Preferred experience

Manufacturing experience and/or experience in the Microsoft partner channel is especially valuable. The following qualifications strengthen a candidate profile; depth in every area is not expected.

• Manufacturing knowledge, such as production planning, bills of material, material requirements planning, scheduling, procurement, or inventory processes.
• Microsoft partner-channel experience in technical consulting, solution architecture, implementation, or integrations, including exposure to Dynamics 365 or other ERP systems.
• Predictive modeling, time-series forecasting, simulation, mathematical optimization, or model deployment and monitoring.
• Infrastructure as code with Bicep or Terraform, CI/CD with Azure DevOps or GitHub Actions, and automated environment provisioning.
• FastAPI, React, JavaScript, data visualization, and interactive analytical applications.
• Relevant Microsoft or Databricks certifications. Certifications support, but do not replace, demonstrated practical capability.

Domain learning and collaboration

Learn unfamiliar business concepts through collaboration with subject-matter experts. Restate proposed methods accurately, identify their assumptions, test their implementation, and question implausible results. Advanced operations research expertise is welcome; strong quantitative foundations and demonstrated learning ability are essential.

Professional expectations

• Take ownership of quality, follow issues through to a verified resolution, and communicate progress and blockers clearly.
• Distinguish what the evidence establishes from what remains an assumption, and document decisions so others can reproduce the work.
• Balance analytical rigor with practical delivery, seek feedback early, and recognize when deeper domain or platform expertise is needed.

$160,000 - $220,000 a year

Plus additional supplemental compensation (bonus) paid quarterly

Why work for MCA Connect?

Our compensation plan offers one of the best bonus structures in the industry. Along with this we also offer a generous benefit package:

• Work/Life Balance with Unlimited Paid Time Off (UPTO)
• 401k Plan with Company Matching Contribution
• Monthly Stipend for Home Office Expenses
• Subsidized Medical, Dental and Vision Coverage
• Health Savings and Flexible Spending Accounts
• Company Paid Life and Disability Insurance
• Training, Certification and Continuing Education Support

MCA Connect offers limitless opportunities for personal and professional growth in a stimulating, challenging, and performance-oriented work culture where you can share your ideas and make impactful daily contributions. Our employees are highly motivated and talented individuals dedicated to developing, marketing, and selling products designed to deliver value for mid-market and enterprise-size manufacturing, distribution, and energy companies. We take the time to train our consultants so that they understand the industries we serve and can deliver best practices, proven methodologies, and ongoing industry expertise to our clients.

MCA Connect is an Equal Opportunity Employer. MCA Connect promotes equal employment opportunity to all employees and applicants and does not discriminate on the basis of race, religion, color, creed, national origin, sex, age, sexual/gender orientation, status as a protected disabled or Vietnam Era Veteran, disability, or any other legally protected status.We firmly believe our differences make us stronger!