Job Information
Beacon Hill Staffing Group, LLC Data Warehouse Developer in Saint paul, Minnesota
Beacon Hill was founded to set a new standard in search, career placement and flexible staffing. Data Warehouse Developer Location: 100% Remote Type: Contract Duration: Long Term, Open Ended *Candidates MUST have Alteryx experience related to ETL, not just Alteryx experience based in data prep. Candidates will be required to write complex SQL queries with Alteryx. Role Overview We are seeking an experienced Data Warehouse Developer to support enterprise data initiatives focused on building, enhancing, and maintaining data integration and data warehouse solutions. This role will contribute to a collaborative, agile team responsible for delivering reliable, high-quality data to support analytics and business decision-making. The ideal candidate has strong hands-on experience designing, developing, testing, and maintaining ETL pipelines and working with large, complex datasets in a data warehouse environment. Key Responsibilities * Gather and translate business and technical requirements into detailed ETL technical specifications * Design, develop, test, and debug ETL workflows using enterprise ETL tools * Build and maintain data pipelines supporting incremental, full/history, and survivorship-based data loads * Implement and support Change Data Capture (CDC) processes * Develop, optimize, and maintain complex SQL used for data transformations and integrations * Schedule, monitor, and troubleshoot ETL jobs and data workflows * Load and manage data warehouse structures to support reporting and analytics * Collaborate with team members in an agile development environment * Contribute to data quality, reliability, and performance improvements Required Skills & Experience * 6+ years of experience gathering requirements and developing ETL technical specifications * 6+ years of experience designing and developing ETL jobs ? Minimum 2 years of hands-on experience with Alteryx * 6+ years of experience developing data loads (incremental, full/history, survivorship rules) * 4+ years of experience implementing Change Data Capture (CDC) * 6+ years of experience testing and debugging ETL processes * 6+ years of experience developing complex SQL * 2+ years of experience with ETL job scheduling * 2+ years of experience loading data warehouses using ETL tools Preferred / Nice-to-Have Skills * Experience working with multiple ETL tools * Experience with data quality tools and frameworks * Experience using source control/version control tools (e.g., Git) * Strong communication and collaboration skills * Ability to manage multiple tasks and priorities in a fast-paced environment Technology Environment * Alteryx * SQL Server * SSIS / SSRS * Tableau * Semarchy * Git / GitHub Beacon Hill is an equal opportunity employer and individuals with disabilities and/or protected veterans are encouraged to apply. California residents: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser: https://jobs.beaconhillstaffing.com/eeoc/ Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records. Company Profile: Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs. Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Anal sis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles. Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.bhsg.com . Benefits Information: Beacon Hill offers a robust benefit package including, but not limited to, medical, dental, vision, and federal and state leave programs as required by applicable agency regulations to those that meet eligibility. Upon successfully being hired, details will be provided related to our benefit offerings. We look forward to working with you. Beacon Hill. Employing the Future Apply here: https://www.aplitrak.com/?adid=YmJnZW5lcmljLjg3NjIzLjEwNTA2QGJlYWNvbmhpbGxjb21wLmFwbGl0cmFrLmNvbQ