Bachelor's degree in computer science, information systems, or related field, or equivalent experience
2+ years in data engineering, data warehouse development, or related discipline
Strong SQL skills, including joins, transformations, and query optimization
Experience with cloud data platforms like Microsoft Fabric or Azure
Familiarity with Git or another source control system
Excellent problem-solving and communication skills
Self-motivated with strong organizational abilities
Responsibilities
Develop and maintain data ingestion and transformation processes
Build solutions using Microsoft Fabric capabilities
Support migration of data from Snowflake and SQL Server to Microsoft Fabric
Implement business rules and transformations for reporting
Monitor and improve pipeline execution and resource utilization
Collaborate with teams to clarify requirements and coordinate delivery
Maintain documentation of data flows and operational procedures
Benefits
Health, dental, and vision insurance
Paid time off
401(k) with matching contributions
Life and disability insurance
In-house training programs
Tuition reimbursement
Employee referral bonus program
Tool allowances and loans
Discounts on cellular service, computers, and vehicles
Opportunities for overtime
Full Job Description
Job Title: Cloud Data Warehouse Developer
Location: Richmond, Virginia
Starting Compensation Range: $89,000 - $115,000 per year
What You Will Do:
Data Pipeline Development: Develop and maintain data ingestion, transformation, and integration processes that move data from source systems into the enterprise data platform
Microsoft Fabric Development: Build and support solutions using Microsoft Fabric capabilities, including Data Factory pipelines, Lakehouse, Warehouse, and notebooks, as appropriate
Platform Migration: Support migration of data, transformations, and processing workloads from Snowflake and SQL Server to Microsoft Fabric, including testing, reconciliation, and production transition
Data Modeling: Develop and maintain tables, views, and dimensional models according to architecture standards and business requirements
Data Transformation: Implement business rules and transformations that prepare data for reporting and analytics, following approved patterns for Bronze, Silver, and Gold layers
Data Quality and Validation: Build automated validation checks and collaborate with data quality team to identify, investigate, and resolve data issues
Performance and Cost Optimization: Monitor and improve pipeline execution, query performance, and resource utilization to support reliable and cost-effective processing
Production Support: Monitor scheduled workloads, troubleshoot failures, investigate root causes, and implement durable fixes
Security and Governance: Apply approved access controls, data protection requirements, naming conventions, and governance standards
Documentation and Lineage: Maintain documentation of source mappings, transformation logic, dependencies, data flows, and operational support procedures
Development Practices: Use source control, peer reviews, testing, and approved deployment processes to deliver maintainable solutions
Collaboration: Work with Data Architect, application teams, reporting developers, and business stakeholders to clarify requirements and coordinate delivery
Continuous Improvement: Identify opportunities to reduce manual work, improve reliability, and simplify existing data processes
Perform other related duties as assigned
What We're Looking For:
Bachelor's degree in computer science, information systems, or a related field, or an equivalent combination of education and relevant experience
Two or more years of experience in data engineering, data warehouse development, database development, or a related discipline
Experience developing SQL-based data solutions and supporting scheduled data processing workloads
Strong SQL skills, including joins, transformations, stored procedures, and query optimization
Understanding of data warehousing concepts, relational databases, and dimensional modeling
Experience developing and supporting ETL or ELT pipelines
Experience with a cloud data platform such as Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, Snowflake, or an equivalent platform
Understanding of incremental loading, dependency management, scheduling, and error handling
Familiarity with Git or another source control system
Must be able to effectively resolve issues in a timely manner using sound judgement, critical thinking, problem solving, decision making, and influencing skills
Strong organization skills with the ability to effectively prioritize (with changing priorities), multi-task, address issues quickly and professionally, and meet deadlines
Self-motivated with strong work ethics
Excellent written and oral communication skills
Valid driver's license
Excellent driving record
Willingness to travel to other locations and conduct on premise training sessions
Preferred:
Hands-on experience with Microsoft Fabric, including Lakehouse, Warehouse, Data Factory pipelines, and notebooks
Experience with Python, PySpark, Spark SQL, or Delta Lake
Experience migrating workloads from Snowflake or SQL Server to a cloud data platform
Familiarity with Power BI semantic models and the data structures that support them
Experience integrating ERP, API, or legacy source-system data
Familiarity with automated testing, CI/CD, and deployment across development, test, and production environments
Relevant Microsoft Fabric, Azure, or data engineering certifications
What Success Looks Like In This Role:
Developed data ingestion, transformation, and integration processes
Built solutions using Microsoft Fabric capabilities, including Data Factory pipelines, Lakehouse, Warehouse, and notebooks
Supported migration of data, transformations, and processing workloads from Snowflake and SQL Server to Microsoft Fabric, including testing, reconciliation, and production transition
Developed tables, views, and dimensional models
Implemented business rules and transformations that prepare data for reporting and analytics
Functioning well in a high volume and fast-paced environment
Successful troubleshooting data discrepancies, pipeline failures, and performance issues
Translated business requirements into tested, documented technical solutions
Positive working relationships
Clear and concise communication of technical information to non-technical users
Effectively working independently and in team settings
Promoting positive customer experience
Upholding the Core Values of Integrity, Commitment, Excellence and Teamwork by embracing The Carter Way
Physical Requirements:
Regularly required to sit and talk or hear
Frequently required to stand; walk; use hands to finger, handle, or feel and reach with hands and arms
Occasionally lift and/or move up to 20 pounds
Specific vision abilities required by this job include close vision, distance vision and ability to adjust focus
Competitive Compensation and Benefits:
Health, dental and vision insurance
Paid time off
401(k), $0.75 to $1.25 match up to 6%
Life and disability insurance
In-house training instructors/programs
Tuition reimbursement
Employee referral bonus program
Tool allowances and tool loans
Discounts on cellular phone service, computers, and vehicles
Opportunities for overtime
Shift differential (if applicable)
Actual base pay may vary based on experience, skills, qualifications, education, geographic location, and other relevant business considerations. In addition to base pay, the compensation package may include participation in performance-based incentive programs (e.g., discretionary or non-discretionary plans), as well as overtime eligibility depending on the role.
