Design, build, and operationalize cloud-based data pipelines and transform raw data into analysis-ready datasets. Collaborate with business, analytics, and engineering teams to develop data models, automate data preparation, and document transformations. Support Power BI models and dashboards, improve data accessibility and reliability, and mentor peers while exploring new data technologies and automation techniques.
Description
At CDW, we make it happen, together. Trust, connection, and commitment are at the heart of how we work together to deliver for our customers. It's why we're coworkers, not just employees. Coworkers who genuinely believe in supporting our customers and one another. We collectively forge our path forward with a level of commitment that speaks to who we are and where we're headed. We're proud to share our story and Make Amazing Happen at CDW.
* Job Summary
* The Analytics Engineer II plays a pivotal role in designing, building, and operationalizing data solutions that power analytics, reporting, and data‑driven decision‑making across the enterprise. This role blends software engineering rigor with analytics‑focused data modeling by developing scalable data pipelines, transforming raw data into consumable datasets, and supporting analytics teams with well‑structured, high‑quality data assets. The Analytics Engineer II partners closely with business and technical teams to improve data models, enhance data accessibility, and automate complex data preparation tasks using modern cloud platforms and engineering best practices.
* What you will do:
* Build and optimize full‑stack, cloud‑based data systems and pipelines that deliver high‑quality, analysis‑ready datasets for business and analytics teams
* Interface with other technology teams to build Azure Data Pipelines to integrate with Data Lake and other enterprise platforms
* Enhance ingestion, transformation, and orchestration workflows aligned with enterprise architecture standards
* Collaborate with other technology teams to help engineer data sets and curate semantic models that support analytics, machine learning, KPI reporting, and business intelligence use cases.
* Partners with business teams to enhance data models supporting business intelligence tools, increase data accessibility, and foster data-driven decision-making throughout the organization.
* Partner with analysts and data scientists to translate business requirements into scalable engineering solutions that improve data accessibility and reliability.
* Share your passion for staying on top of tech trends, experimenting with and learning new technologies, participating in internal & external technology communities, mentoring other members of the engineering community.
* Collaborate with digital product managers and deliver robust cloud-based solutions that drive powerful experiences and support enterprise‑wide analytics decision‑making
* Responsible for using innovative and modern tools, techniques, and architectures to partially or completely automate the most-common, repeatable, and tedious data preparation and integration tasks to minimize manual and error-prone processes and improve productivity.
* Be curious and knowledgeable about new data management techniques and how to apply them to solve business problems.
* Document data flows, transformations, and modeling logic to promote consistency and trust in delivered datasets.
* What we expect of you:
* BS degree in Computer Science, Information Systems, Business Analytics, or a related technical field
* and
* 3 years of data application development experience using Azure Data Factory/Fabric Data Factory or SSIS,
* 5+ years of data application development experience using Azure Data Factory/Fabric Data Factory or SSIS.
* Experienced researching technical and business questions with minimal oversight.
* Intermediate to advanced SQL and/or Python skillsets to transform and analyze data, building or supporting data pipelines, and delivering datasets used for reporting or analytics.
* Experience in developing Power BI data models and dashboards
* Ability to work independently on moderately complex tasks.
* Ability to effectively communicate and collaborate with business partners and technical teams.
* Experience in Agile project management methodologies
* Experience experimenting with AI agents, LLM‑based tools, or prompt‑driven automation to enhance analytics or data workflows Pay range: $86,000 - $119,600 depending on experience and skill set Benefits overview: [https://cdw.benefit-info.com/](https://cdw.benefit-info.com/) Salary ranges may be subject to geographic differentials
* We make technology work so people can do great things.
* CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index, CDW helps its customers to navigate an increasingly complex IT market and maximize return on their technology investments. Together, we unite. Together, we win. Together, we thrive. CDW is an equal opportunity employer. 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. CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, CDW's goal is to get to know you as an applicant and understand your experience, strengths, skills, and qualifications. While AI can help you present yourself more clearly and effectively, the essence of your application should be authentically yours. To learn more, please review [CDW's AI Applicant Notice](https://www.cdwjobs.com/pages/ai-applicant-notice).
At CDW, we make it happen, together. Trust, connection, and commitment are at the heart of how we work together to deliver for our customers. It's why we're coworkers, not just employees. Coworkers who genuinely believe in supporting our customers and one another. We collectively forge our path forward with a level of commitment that speaks to who we are and where we're headed. We're proud to share our story and Make Amazing Happen at CDW.
* Job Summary
* The Analytics Engineer II plays a pivotal role in designing, building, and operationalizing data solutions that power analytics, reporting, and data‑driven decision‑making across the enterprise. This role blends software engineering rigor with analytics‑focused data modeling by developing scalable data pipelines, transforming raw data into consumable datasets, and supporting analytics teams with well‑structured, high‑quality data assets. The Analytics Engineer II partners closely with business and technical teams to improve data models, enhance data accessibility, and automate complex data preparation tasks using modern cloud platforms and engineering best practices.
* What you will do:
* Build and optimize full‑stack, cloud‑based data systems and pipelines that deliver high‑quality, analysis‑ready datasets for business and analytics teams
* Interface with other technology teams to build Azure Data Pipelines to integrate with Data Lake and other enterprise platforms
* Enhance ingestion, transformation, and orchestration workflows aligned with enterprise architecture standards
* Collaborate with other technology teams to help engineer data sets and curate semantic models that support analytics, machine learning, KPI reporting, and business intelligence use cases.
* Partners with business teams to enhance data models supporting business intelligence tools, increase data accessibility, and foster data-driven decision-making throughout the organization.
* Partner with analysts and data scientists to translate business requirements into scalable engineering solutions that improve data accessibility and reliability.
* Share your passion for staying on top of tech trends, experimenting with and learning new technologies, participating in internal & external technology communities, mentoring other members of the engineering community.
* Collaborate with digital product managers and deliver robust cloud-based solutions that drive powerful experiences and support enterprise‑wide analytics decision‑making
* Responsible for using innovative and modern tools, techniques, and architectures to partially or completely automate the most-common, repeatable, and tedious data preparation and integration tasks to minimize manual and error-prone processes and improve productivity.
* Be curious and knowledgeable about new data management techniques and how to apply them to solve business problems.
* Document data flows, transformations, and modeling logic to promote consistency and trust in delivered datasets.
* What we expect of you:
* BS degree in Computer Science, Information Systems, Business Analytics, or a related technical field
* and
* 3 years of data application development experience using Azure Data Factory/Fabric Data Factory or SSIS,
* 5+ years of data application development experience using Azure Data Factory/Fabric Data Factory or SSIS.
* Experienced researching technical and business questions with minimal oversight.
* Intermediate to advanced SQL and/or Python skillsets to transform and analyze data, building or supporting data pipelines, and delivering datasets used for reporting or analytics.
* Experience in developing Power BI data models and dashboards
* Ability to work independently on moderately complex tasks.
* Ability to effectively communicate and collaborate with business partners and technical teams.
* Experience in Agile project management methodologies
* Experience experimenting with AI agents, LLM‑based tools, or prompt‑driven automation to enhance analytics or data workflows Pay range: $86,000 - $119,600 depending on experience and skill set Benefits overview: [https://cdw.benefit-info.com/](https://cdw.benefit-info.com/) Salary ranges may be subject to geographic differentials
* We make technology work so people can do great things.
* CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index, CDW helps its customers to navigate an increasingly complex IT market and maximize return on their technology investments. Together, we unite. Together, we win. Together, we thrive. CDW is an equal opportunity employer. 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. CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, CDW's goal is to get to know you as an applicant and understand your experience, strengths, skills, and qualifications. While AI can help you present yourself more clearly and effectively, the essence of your application should be authentically yours. To learn more, please review [CDW's AI Applicant Notice](https://www.cdwjobs.com/pages/ai-applicant-notice).
Top Skills
Azure
Azure Data Factory
Azure Data Lake
Fabric Data Factory
Llm-Based Tools
Power BI
Python
SQL
Ssis
Similar Jobs at CDW
Information Technology
Manage internal coordination for the LA28 partnership, oversee project deliverables, align teams, and maintain fiscal accountability to meet strategic objectives.
Top Skills:
Itil FrameworkMS OfficeMicrosoft Project
Information Technology
Lead end-to-end professional services engagements, manage client relationships and delivery teams, ensure on-time profitable delivery, drive upsell/cross-sell, mentor staff, monitor KPIs, and mitigate risks to support revenue growth.
Information Technology
Lead design, deployment, and optimization of enterprise Splunk environments; develop dashboards, alerts, correlation searches, and data models; onboard and validate data sources; troubleshoot performance and ingestion issues; support compliance/auditing; mentor junior staff and maintain strict adherence to classified environment protocols.
Top Skills:
Splunk Enterprise,Splunk Es,Splunk Itsi,Universal Forwarder,Heavy Forwarder,Indexer,Search Head,Spl,Cim,Siem,Syslog,Apis,Ansible,Python,Terraform,Aws,Azure,Govcloud
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
