Software Engineer II Data

CDW; United States; Remote; USD 86,000 - 119,000; Full time

Job summary

CDW is seeking a Software Engineer II, Data to design and support enterprise data ingestion, transformation, modeling, and integration solutions. You will translate business requirements into scalable data pipelines and models to enable analytics, reporting, and downstream applications.

The role focuses on building ingestion/transformation solutions with Microsoft Fabric and ADF, working with Azure services, and ensuring data quality across complex data architectures.

Qualifications

• Bachelor's degree in CS/IS/Engineering or equivalent with 3 years IT experience, or 7 total IT years.
• Experience building enterprise data pipelines, data warehouses, Lakehouse, or analytics platforms.
• Strong SQL and relational DB development; ability to troubleshoot data issues.
• Excellent analytical, problem-solving, and cross-functional communication.
• Experience with Agile, DevOps, CI/CD, and Git/GitHub.
• Experience with Microsoft Fabric, ADF, Azure Data Lake/Storage, Azure SQL/SQL Server.
• Knowledge of data warehousing, dimensional modeling, data ingestion patterns, validation.
• Familiarity with Python and/or PySpark; Delta Lake/Lakehouse concepts is a plus.
• REST APIs/JSON-based integrations; event-driven patterns and Azure Service Bus are a plus.
• Data migration and legacy modernization, Azure Key Vault security, enterprise data governance is a plus.

Responsibilities

• Build ingestion and transformation solutions using Microsoft Fabric and ADF.
• Implement pipelines for batch, incremental, API, file, DB, and event-based integration.
• Develop reusable ingestion/transformation patterns and curated data structures.
• Work with SQL, CSV, JSON, Parquet and other formats; verify data quality.
• Model data: conceptual, logical, physical; dimensional/curated models.
• Develop complex SQL queries, views, transformations, and data-processing logic.
• Troubleshoot queries, pipelines, data-processing issues; tune performance.
• Perform data quality, reconciliation, and source-to-target checks.
• Use GitHub for source control; follow EDAS CI/CD and code-review standards.
• Utilize Azure DevOps/ADO for delivery; maintain documentation and patterns.
• Monitor production pipelines; resolve failures and long-running jobs.
• Collaborate in peer code/design reviews; improve reusable patterns.

Skills

SQL & relational DB

Analytical skills

Cross-functional collaboration

Agile / DevOps

Python / PySpark

ETL/ELT patterns

Dimensional/Data modeling

Data quality & validation

Git / GitHub

Azure Data Platform

Education

Bachelor's degree in CS/IS/Engineering

Tools

Azure Data Factory

Azure Data Lake/Storage

Azure SQL/SQL Server

Microsoft Fabric

Azure DevOps

GitHub

Job description

Job Summary

The Software Engineer II, Data builds and supports enterprise data ingestion, transformation, modeling, and integration solutions. This role translates business and source-system requirements into scalable, maintainable data solutions that support analytics, reporting, operational, and downstream application needs.

What you will do

Build ingestion and transformation solutions using Microsoft Fabric and Azure Data Factory. Implement pipelines supporting batch, incremental, API, file, database, and event-based integration patterns. Develop reusable and configuration-driven ingestion and transformation patterns where appropriate. Build curated data structures supporting analytics, reporting, operational, and downstream application requirements. Work with structured and semi-structured data, including SQL, CSV, JSON, XML, Parquet, and similar enterprise formats. Work with Azure Data Factory, Azure Data Lake/Storage and Azure SQL/SQL Server. Translate business and source-system requirements into scalable data models. Participate in conceptual, logical, and physical data modeling. Design dimensional and curated models that support enterprise reporting and analytics. Develop complex SQL queries, views, transformations, and data-processing logic. Troubleshoot query, pipeline, and data-processing issues. Perform query and pipeline performance tuning. Identify and resolve data‑quality, integrity, completeness, and consistency issues. Perform source-to-target and source-to-source reconciliation. Develop validation checks for new pipelines and changes. Use GitHub for source control and branch-based development. Follow EDAS CI/CD, pull‑request, code‑review and design‑review standards. Use Azure DevOps (ADO) and approved engineering practices to manage delivery. Create maintainable, reusable, well‑documented code. Participate actively in peer code and design reviews. Create or improve reusable engineering patterns and supporting documentation. Monitor and support production data pipelines and scheduled workloads. Troubleshoot pipeline failures, missed schedules, long‑running processes, and data‑quality issues.

What we expect of you

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Engineering, or a related field and 3 years of relevant IT experience, OR 7 total years of relevant IT experience. Professional experience developing enterprise data pipelines, integrations, data warehouses, Lakehouse solutions, or analytics data platforms. Demonstrated ability to troubleshoot complex data and integration problems. Strong analytical and problem‑solving skills. Strong communication and cross‑functional collaboration skills. Ability to deliver effectively in an Agile enterprise engineering environment. Strong SQL and relational database development. Strong understanding of data engineering and ETL/ELT. Microsoft Fabric. Azure Data Factory (ADF). Azure Data Lake / Storage. Azure SQL / SQL Server. Data warehousing and dimensional/data modeling concepts. Data ingestion and transformation patterns. Data validation and reconciliation. Performance optimization and troubleshooting. Git / GitHub. CI/CD and pull‑request‑based development. Azure DevOps / Agile delivery practices. Python and/or PySpark, a plus. Delta Lake / Lakehouse concepts, a plus. Medallion architecture, a plus. REST APIs / JSON‑based integrations, a plus. Event‑driven integrations and Azure Service Bus, a plus. Data migration and legacy‑platform modernization, a plus. Azure Key Vault and secure credential handling, a plus. Enterprise data governance and data‑quality concepts, a plus. Microsoft Fabric / Azure data engineering certifications, a plus.

Pay range

$86,000 - $119,000, depending on experience and skill set.

Benefits overview

https://cdw.benefit-info.com/

AI Culture

CDW is committed to being an AI‑fluent organization. We’re looking for people who bring curiosity, a learner’s mindset, and a willingness to engage with ever‑evolving technology and tools. We value adopting AI as a partner, openness to experimentation, and a shared interest in learning together on AI. Our goal is to create a culture where AI enhances—not replaces—human creativity and decision‑making. You don’t need to be an expert today; what matters is your readiness to explore, adapt, and grow with us as we integrate AI responsibly and effectively into our work. Additionally, CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, our goal is to understand your experience, strengths, skills, and qualifications. As an AI forward company, we see AI not just as a tool, but as a catalyst for new ways of thinking, creating, and communicating. We encourage candidates to embrace an AI mindset, one that’s curious, adaptive, and ready to explore what’s possible. We welcome thoughtful use of AI to expand your perspective and elevate how you share your story, while ensuring your application remains rooted in your own background, judgment, and voice.

About Us

CDW is a Fortune 500 technology solutions provider that helps businesses, government, education, and healthcare organizations achieve what’s possible through technology. What makes CDW different isn’t just what we do—it’s how we do it. At CDW we act as one—building trust, speaking candidly, and working together to achieve more. We play to win—focusing on what matters most and delivering for our customers. And we think forward—staying curious, moving fast, and continuously learning. We believe meaningful work happens when people feel supported, heard, and empowered to contribute. That’s why we think of ourselves as coworkers, not just employees—working together to solve complex challenges and deliver real impact for our customers and communities. As a full‑stack, full‑lifecycle technology partner, CDW brings deep expertise, strong relationships, and broad industry knowledge to help turn ideas into outcomes. When you join CDW, you become part of a collaborative environment where your work matters, your growth is supported, and your contributions help shape what’s next. Together, we deliver the full promise of what technology can do. Together, we Make Amazing Happen. CDW is an equal opportunity employer.

Equal Opportunity Statement

All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law.

Additional Commitment

Additionally, CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants.

Corporate Presence

At CDW, we make technology work so people can do great things. We are a leading multi‑brand technology solutions provider to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. Our coworkers across the globe are working together to bring technology to life for our customers by solving complicated IT business challenges, providing outstanding service, and orchestrating the technology landscape to optimize our customers’ performance.