Builders FirstSource Software Engineer III Information Technology in Denver, Colorado
Software Engineer III Information Technology
Denver Admin Office - 7595 Technology Way (80237), 7595 E Technology Way, Denver, Colorado, United States of AmericaReq #16668
Tuesday, August 25, 2020
The Sr. ETL DB Developer/SSIS Developer will be working on a new BI implementation project and supporting the current production environment. They will be hands on but will also be teaming with the Manager of the team to contribute and execute the team vision, especially from a process design, improvement and standards perspective. From preliminary business requirements and solution architectures, conducts feasibility analysis and uses comprehensive technical knowledge, creativity and judgment in exploring possible high-level solution designs.
Produces software designs to meet complex requirements within time and cost constraints.
Ensures technical documentation reflects changes to application functionality or implementation choices. Plans, conducts, and supervises assignments.
Reviews progress and results, and communicates with management. Leverages team skills for successful project completion.
Contributes to system design, applying established and emerging database and ETL best practices and standards.
Balances between robustness and speed/cost considerations, optimizing based on what’s appropriate for the solution domain.
Plans overall documentation needs and provides technical documentation relating to system design, application deployment planning, and production support requirements.
Leverages quality best practices including design reviews, unit testing, code reviews, and continuous integration to ensure a defect-free delivery.
Maintains consistency and encourages improvement.
Required Skills and Experience:
Bachelor’s degree in Computer Science or related field and ten (10) years software design and development experience; or equivalent combination of education and experience
Eight (8) years of experience designing and developing ETL solutions
Eight (8) years of experience designing and developing database solutions with SQL Server
Five (5) years of experience with SSIS
Five (5) years of experience working in a complex ETL/Data Warehousing environment
Three (3) years of experience with data visualization and/or reporting environments (MicroStrategy, Tableau, SSRS, etc.)
Advance knowledge in writing SQL queries, stored procedures and functions
Advance knowledge in Data warehousing concepts, tools and methodologies
Comprehensive understanding of the data processing environment, its impact on business functions
Provide support, coaching and mentoring other team members as required
Must be able to translate functional requirements into long term sustainable technical solutions
Must be able to work on both development and production support efforts
Strong data analysis skills with the ability to identify data patterns in order to isolate and produce root cause analysis
Strong communication skills.Should be able to communicate complex technical concepts in a clear, methodical and logical manner to different audiences
Strong technical, logical, analytical and problem solving skills
Should be a team player and willing to share and collaborate with other team members
Experience and comfort working within a blend of either remote and/or onsite locations
Denver Admin Office - 7595 Technology Way (80237), 7595 E Technology Way, Denver, Colorado, United States of America