Senior ETL Developer
Job ID: 135
Location: Manakin-sabot VA
Summit Human Capital is seeking a motivated Sr. ETL Developer in Richmond, Virginia. The ideal candidate will meet the following criteria:
• 6+ years equivalent work experience in Information Technology. • 6+ years of previous experience supporting data warehouse implementations • 4+ years ETL development experience preferably using Microsoft SQL Server Data Tools/BIDS, with deep and thorough hands-on use of T-SQL. • 4+ years of experience in relational and data warehouse database design, optimization and performance; preferably with MS SQL Server. • Expertise/working knowledge in Data Warehouse Practices and Azure Data Factory • 2+ years of experience with API (Application Program Interface) development. • 5+ years in a structured IT organization with a variety of methodologies, and strong technical environment management. • Experience with multiple SDLC methodologies – Waterfall and Agile. • Extensive experience with data dictionaries, data analysis and relational databases. • Proven understanding of SQL optimization (indexing and ability to interpret and act on execution plans).
• Experience with Power BI and other BI tools • Microsoft Azure Certification in Data or Cloud Solutions • Experience with data extraction from Microsoft CRM/ERP (AX and D365) Cloud solutions • Streaming data analytics • Data Science knowledge • PowerShell experience • Four-year degree
• Developing and designing ETL/ELT solutions using data warehouse design best practices specifically cloud solutions • Understand and analyze data needs, complex source data, and the data model, and determine the best methods in extracting, transforming and loading data into the data staging, warehouse and other system integration projects. • Comfortable understanding business requirements • Provide technical assistance in identifying, evaluating, and developing systems and procedures. • Document all ETL and data warehouse processes and flows. • Create or update technical documentation for transition to support teams. • Develop automated data audit and validation processes. • Develop and deploy ETL job workflow with reliable error/exception handling and rollback. • Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, assisting with Database backups and performance tuning. • Design, Develop, Test, Adapt ETL code & jobs to accommodate changes in source data and new business requirements. • Provides senior technical leadership to design, architecture, integration and support of the entire data sourcing platform with a focus on high availability, performance, scalability and maintainability • Manage automation of file processing as well as all ETL processes within a job workflow. • Develop, Contribute and adhere to the development of standards and sound procedural practices. • Proactively communicate innovative ideas, solutions, and capabilities over and above the specific task request • Effectively communicate status, workloads, offers to assist other areas. • Collaboratively work with a team and independently. Continuously strive for high performing business solutions • Perform and coordinate unit and system integration testing. • Participate in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications. • Ensure data quality throughout entire ETL process, including audits and feedback loops to sources of truth.