CLOUD DATA WAREHOUSE DEVELOPER

Join a Company That’s Built to Elevate You. At Carter Machinery, we don’t just offer jobs - we offer long-term careers defined by purpose, innovation, and impact. We’ve built an award-winning workplace where high achievers thrive, careers grow, and your work truly matters. Our legacy is strong, our vision is bold, and our future is built on investing in the growth and well-being of our people. Whether you're turning a wrench, managing operations, or supporting customers, you play a vital role in powering industries that moves the world forward. 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) You’ll gain access to real learning, real advancement, and a real future in a company that’s reshaping what it means to lead in our industry. If you're looking for purpose, possibilities, and a team that wins together - you belong at Carter Machinery. Come build what matters and build your future with us. 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. Carter Machinery Co. Inc. is an EEO/AA Employer. All qualified individuals – including minorities, females, veterans, and individuals with disabilities, or any other characteristic protected by law – are encouraged to apply. Carter Machinery is a drug-free workplace.