The Lead Application Developer (DWBI/ETL) is a technical expert focused on development management, coordinating and optimizing the efforts of a team of technical developers. Involved in medium to large projects throughout all phases of the SDLC, this role produces the technical design and solution architecture which is consumed by the development team. This role acts as a technical coach/advisor, implements and ensures adherence to standards and best practices, and helps maintain consistency across projects.
Key Areas of Responsibility
Translate business requirements into appropriate technical design and solution architecture to maximize efficiency, maintainability, scalability for medium to large DWBI projects
Oversee, direct and focus the efforts of a team of ETL developers who have the following responsibilities across all stages of the SDLC:
Work with business SMEs to identify and understand source data systems
Map source system data to data warehouse models
Develop and test extraction, transformation, and load (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
Technical owner of the scripts produced to extract, transform, clean, and move data from sources into a data warehouse, data mart, or operational data store
Determines resource needs for assigned projects and assigns development tasks for efficiency in collaboration with a project manager and also without
Provides coaching to continually build the technical skillsets and proficiency of developers
Actively researches relevant technologies and methods, recommends and implements new and innovative ideas for improvement
Develops and promotes standards and best practices
Identify and draw appropriate resources together in order to address technical issues spanning multiple teams/technologies
Collaborate with business and project teams to gather requirements and business needs.
Make technical decisions to meet the design goals laid out in product road map and by management.
Identify issues that require more attention, and work to resolve issues based on an understanding of the business problem being solved.
Draw appropriate resources together in order to address technical issues.
Direct and focus the efforts of the technical project team.
Monitor progress of project teams.
Mentor and coach junior team members.
Complete projects/tasks on a timely basis, according to commitments made to stakeholders and management.
Report project/task status to the management.
Bachelor’s degree or equivalent IT knowledge/experience.
10 years application development experience, or 7 years CDW Application Development experience
Other Required Qualifications
Expertise in developing applications
Demonstrated ability to coach and mentor others.
Advanced knowledge of product lifecycle and understanding of the role of methodology/frameworks.
Advanced knowledge of object-oriented design, and programming techniques.
Demonstrated ability to build rapport and maintain productive working relationships cross-departmentally and cross-functionally.
Excellent written and verbal communication skills with the ability to effectively interact with and present to all stakeholders including senior leadership.
Strong organizational, planning and creative problem solving skills with critical attention to detail.
Demonstrated success of facilitation and solutions implementation.
Proven track record of leading application development projects.
History of balancing competing priorities with the ability to adapt to the changing needs of the business while meeting deadlines.
DWBI Required Qualifications
10 years using software design support tools and productivity suites such as Microsoft Visio, Microsoft Office, and Microsoft Project
8 years software application development experience in data warehousing and business intelligence
6 years experience with data warehousing tools including ER Studio or similar, SQL Server, T-SQL, stored procedures, SSIS
4 years experience with data warehouse data architecture/modeling
Extensive knowledge of data warehousing and business intelligence technologies, methodologies, processes throughout the full lifecycle
Translate business requirements into technical requirements documentation
Design advanced multi-dimensional star/snowflake data models, cubes, and ETL jobs
Investigate and understand source and target data, perform data profiling
Strong database administration, especially performance tuning, columnstore indexes
Metadata capture, management
Expert in ER Studio, SQL Server (SQL, stored procedures, SSIS)
DWBI Preferred Qualifications
Lead Application Developer - DWBI