Data Engineer Consultant (remote)
Role details
Job location
Tech stack
Job description
Own and optimize data infrastructure and ETL/ELT pipelines using SSIS and Microsoft Fabric. Build and maintain SQL Server data warehouse staging, transformations, and lakehouse ingestion. Implement CI/CD, version control with GitHub, monitor pipeline health, troubleshoot data issues, document data flows, and translate stakeholder requirements into data engineering solutions that support BI reporting., We're looking for a Senior Data Engineering Consultant who can own the data infrastructure that powers our analytics environment. You'll build and maintain ETL pipelines, develop and optimize our SQL Server data warehouse, design Fabric lakehouse ingestion workflows, and establish CI/CD practices for our data assets, all while working remotely with our USA-based team. The ideal candidate is self-sufficient, understands how data flows from source to consumption, and can navigate a complex data environment with minimal guidance., * Develop, maintain, and optimize ETL/ELT pipelines using SSIS and Microsoft Fabric
- Build and maintain data warehouse staging, transformation, and loading processes in SQL Server
- Design and implement data ingestion workflows from multiple source systems into SQL Server and Fabric lakehouses
- Write and optimize complex SQL queries, stored procedures, and indexing strategies
- Design and maintain star schemas, dimensional models, and data warehouse architecture
- Monitor pipeline health, troubleshoot data issues, and implement error handling and logging
- Implement and maintain CI/CD pipelines for automated testing and deployment of data assets
- Manage version control for data pipelines, SQL objects, and BI assets using GitHub
- Document data flows, transformation logic, pipeline architecture, and business rules thoroughly
- Gather requirements from stakeholders and translate them into data engineering solutions
- Collaborate with the BI team to ensure data models support downstream reporting needs, The Data Engineer Consultant will develop scalable data infrastructure, optimize SQL queries, design dimensional models, create visual dashboards, and collaborate with clients to meet data needs.
Requirements
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field
- 3+ years of experience in data engineering or data warehouse development
- Strong SQL Server skills (complex queries, stored procedures, performance tuning, indexing)
- Hands-on ETL/ELT pipeline development experience with SSIS
- Experience with Microsoft Fabric (lakehouses, data pipelines, analytics workloads)
- Solid understanding of data warehouse architecture, star schemas, and dimensional modeling
- Experience with Git/GitHub for version control
- Familiarity with CI/CD concepts and deployment automation
- Strong documentation skills
- Excellent written and verbal communication in English and Spanish
- Ability to work independently with minimal supervision
Preferred qualifications
- Microsoft DP-600 (Fabric Analytics Engineer) or DP-203 (Data Engineer) certification
- Experience implementing CI/CD pipelines for data engineering or BI workflows (e.g., Azure DevOps, GitHub Actions)
- Experience leveraging AI tools (e.g., Claude, Copilot, ChatGPT) to accelerate development and analysis
- Power BI experience (report development, DAX, Power Query, semantic models)
- Experience in manufacturing, production, or retail environments
- Background in operations or supply chain data
- Knowledge of data governance and security best practices
Benefits & conditions
3 Minutes Ago In-Office or Remote 245K-308K Annually Senior level 245K-308K Annually Senior level Blockchain * Fintech * Payments * Financial Services * Cryptocurrency * Web3 Lead strategy and GTM for agentic commerce on Arc, driving ecosystem partnerships, product alignment, and adoption of USDC and Circle Agent Stack across AI builders, platforms, and enterprises. Top Skills: Agent MarketplaceAgent WalletsAPIsArcBlockchainCircle Agent StackCircle SkillsDeveloper PlatformsNanopaymentsPaymentsStablecoinsUsdc Circle
Principal Product Manager
4 Minutes Ago In-Office or Remote 230K-295K Annually Senior level 230K-295K Annually Senior level Blockchain * Fintech * Payments * Financial Services * Cryptocurrency * Web3 Lead growth for Arc Network and Circle platform products by driving developer and user adoption, designing growth loops, building developer-facing tooling (APIs/SDKs), coordinating cross-functional launches, ensuring regulatory alignment, and scaling ecosystem integrations across chains and protocols. Top Skills: APIsArc HubArc NetworkBridgesCctpCross-Chain InteroperabilityCustody SolutionsDeveloper SandboxesL1L2Programmable WalletsSdksUsdc
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