A Sr BI Data Engineer is a senior level ETL developer. Activities include: Provide project and team leadership, map source system data to data warehouse models, develop and test ETL processes, define and capture metadata and rules associated with ETL processes, adapt ETL processes to accommodate changes in source systems and new business user requirements. and to demonstrate work ethic that motivates and encourages others on their team. Sr BI Data Engineers are encouraged to bring fresh ideas, new perspectives, and an eagerness to learn new technologies.
Responsible for the scripts required to extract, transform, clean, and move data and metadata so they can be loaded into the appropriate data mart. Work with business requirements analysts to identify and understand source data systems.
Map source system data to data mart models.
Develop and test ETL processes.
Define and capture metadata and rules associated with ETL processes. Adapt ETL processes to accommodate changes in source systems and new business user requirements.
Major Tasks, Responsibilities and Key Accountabilities
65%- Writing new ETL processes and test cases
15%- Debugging existing ETL processes
10%- Learning new skills
10%- Helping with solution design and architecture
Nature and Scope
This role reports to the Manager of BI Data Engineer. This position has no direct reports.
Environmental Job Requirements
1. Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.
Must be eighteen years of age or older.
Must be legally permitted to work in the United States.
The knowledge, skills and abilities typically acquired through the completion of a high school diplomas and/or GED.
Years of Relevant Work Experience - 1
Physical Job Requirements
Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.
- Understanding of source and target data structures, ETL processes, and products Knowledge of 3GL/4GL programming languages and ETL products
- Strong problem-solving and metadata skills
- Ability to work independently and in groups
- Analytical thinking
- Critical thinking
- Attention to detail
- Strong oral and written communication
- Thorough understanding of data structures and algorithms
Knowledge, Skills, Abilities and Competencies
Responsible for the scripts required to extract, transform, clean, and move data and metadata so they can be loaded into a data warehouse or data mart.
PROBLEM SOLVING - Work collaboratively with business stakeholders, BI Data Architects, Lead Data Quality Analysts, and your fellow BI Data Engineers to design and create solutions to complex data issues. Build domain knowledge and understand the user & business problems you're solving.
QUALITY DELIVERABLES - Good data architecture - at QuoteCenter every developer is an architect. You are responsible for creating systems that are appropriately maintainable, scalable, and extensible.
TAKING OWNERSHIP - When a problem comes to your attention, take care of it. If you're too busy with something more important either assign it to someone else or set a reminder to come back to it later.
ALWAYS LEARNING - Be willing to learn whatever technologies, tools, or patterns necessary to solve a problem. Don't avoid a problem because "someone else 'owns' the code" - learn the code, learn the domain, solve the problem.
ALWAYS A MENTOR Continually look for the chance to share your knowledge and skills with others. Even the most seasoned professional can learn new tricks from the most junior developer. There is always something you know that someone else doesnt (and vice versa), so share!
EFFECTIVE COMMUNICATION - Write and speak clearly and concisely. Be prepared to explain your work, decisions, and ideas to your colleagues. Graciously challenge ideas that don't seem right, no matter where they originate.
GOOD TEAMMATE - Have a sense of humor. Build relationships with your colleagues. Work out differences with your colleagues directly. Go to your manager if you're unable to resolve it there. Actively work to disrupt backchannel and office politics. Look for ways to make the work environment better for everyone.
We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.