Top Skills & Years of Experience: Gathering requirements and developing technical specifications for ETL – 6 years Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx) Developing various types of data loads (e.g. incremental, history/full, survivorship rules) – 6 years Implementing change data capture (CDC) – 4 years Testing and debugging ETL – 6 years Developing complex SQL – 6 years ETL job scheduling – 2 years Loading data warehouses using ETL tools – 2 years Nice to Have: Management of multiple ETL tools Experience with data quality tools and frameworks – preferred Using source code version control software – preferred Interview Process: 1-2 rounds via Microsoft Teams. Onsite or Remote? This position can work 100% remote or in the office. Job Description We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position will work on a small, collaborative team that uses agile practices to deliver value to our business partners. Desired Experience Gathering requirements and developing technical specifications for ETL – 6 years Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx) Developing various types of data loads (e.g. incremental, history/full, survivorship rules) – 6 years Implementing change data capture (CDC) – 4 years Testing and debugging ETL – 6 years Developing complex SQL – 6 years ETL job scheduling – 2 years Loading data warehouses using ETL tools – 2 years Management of multiple ETL tools Experience with data quality tools and frameworks Using source code version control software Mentoring to others on ETL development Managing multiple, concurrent projects and tasks Having strong interpersonal skills including communication, mentoring, collaborating, and team building ETF Technologies Alteryx SSIS SSRS SQL Server Tableau Semarchy Git & github Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. 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: 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 Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles. Learn more about Beacon Hill Staffing Group 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 . We look forward to working with you. Beacon Hill. Employing the Future (TM)
Git SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) GitHub Tableau SQL ETL alteryx