Senior Data Engineer
This is a full time, direct hire position working for our client. 3 days on-site a week.
- A minimum of 5 years of demonstrated experience in ETL processes using enterprise-level ETL tools (e.g., Informatica, SSIS, Talend, Matillion, Pentaho).
- Bachelor’s degree in computer science, information technology, or a related field.
- Proficiency in SQL and expertise in database systems, with a preference for experience in enterprise relational databases, such as Snowflake.
- Hands-on experience with Microsoft and Unix platforms.
- Strong knowledge of scripting languages (e.g., Powershell) and job schedulers.
- Familiarity with various integration patterns, including Flat Files and Web Services.
- Solid understanding of fundamental data modeling concepts, including ER Diagrams and normalization.
- Experience with data warehousing techniques, such as dimensional modeling and star schema.
- Ability to write technical documentation effectively.
- Excellent troubleshooting and problem-solving skills, with the capability to debug complex code efficiently.
- Aptitude for understanding the business context of problems to ensure optimal solutions.
- Strong communication skills and the ability to work in a fast-paced, high-impact environment.
- Conduct data profiling, source-target mappings, ETL development, SQL tuning, optimization, testing, and implementation.
- Provide business and technical analysis for Data Warehouse and Business Intelligence initiatives.
- Influence data warehouse design with recommendations for efficient data structuring.
- Develop detailed technical specifications and ETL documentation in collaboration with data warehouse architects and Business Intelligence developers.
- Lead both onshore and offshore developers to ensure efficient delivery of high-quality solutions.
- Mentor ETL developers and conduct peer reviews, offering feedback on ETL design and implementation.
- Design and develop ETL code, ETL audit controls, and scheduling processes.
- Develop testing strategies and conduct testing to identify and resolve data quality issues.
- Collaborate with Business Intelligence Developers throughout dashboard and application development, including requirements gathering, design feedback, and acceptance testing.
- Independently build custom solutions, even when requirements are not clearly defined.
- Stay current with emerging technologies and industry best practices.
- Familiarity with Python.
- Experience with XML/XSLT.
- Knowledge of Snowflake and Talend.
- Cloud platform experience (AWS/Azure).