A key part of GuideHouse's work with clients involves leveraging GuideHouse’s data management infrastructure and ensuring data is loaded in data warehouses and DataMart by adopting latest ETL techniques. The Sr ETL Developer position plays a vital role in data management and product development team by working with business and technical leads to implement proven data management processes. The ideal candidate for this role has experience with managing 3-4 resources work, ETL coding in SSIS, overviewing the work performed by team, has passion for automation and developing scalable solutions. The candidate is someone who keeps abreast with latest trends in MSBI technology and can make suggestions/improvements.
Receives assignments from technology team lead in the form of objectives and technical designs to implement technical solution.
Manages deliverables as well as team deliverables and raises the bar by implementing latest technologies.
Engages with team members business analysts, client service teams and data scientists to understand data needs for the project, produce technical design documents and develop ETL solutions.
Strong Knowledge of SQL and T-SQL, coding and tuning complex queries.
Analyze and improve ETL framework and workflows, develop new packages and troubleshoot.
Run ETL (extract, transform, load) processes to populate standard data models and data warehouse confirming data integrity.
Develop scalable production grade data validation and automation scripts.
Follows data integrity, quality standards, frameworks, d templates, naming conventions, coding standards, and adheres to best data management practices
Mentors junior staff members
Bachelors or Master’s degree in Computer Science, Information Systems, Statistics, Math, Engineering or related discipline
5+ years of hands-on ETL coding experience, preferably using Microsoft SSIS and T-SQL
Experience dealing with large datasets and has proven experience in such environments.
Experience supporting large volumes (terabytes) of incoming data from clients and 3rd party sources in various formats such as text, csv, files and access database formats
Experience with one or more programming languages (C# preferred) in an application development environment or business intelligence tools (Spotfire, Tableau)