TITLE: BI ETL Developer III (Multiple Openings)
LOCATION: Maryland Heights, MO
JOB SUMMARY: Design, develop, and support new and existing Business Intelligence (BI) solutions and transform data into meaningful and accurate information for the business to consume. Participate in active discussions with team members and users to understand business requirements. Work closely with IT, Architecture, Business Analysts and Report Developers to achieve business objectives. Design, develop, implement, and support new and existing data integration jobs using Teradata Stored Procedures. Implement best practice solutions per development standards. Produce ad hoc reports to answer business questions. Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions. Troubleshoot, diagnose and resolve data quality and performance issues. Communicate complex topics and analyses to non-technical business personnel. Provide accurate level of effort estimates for data integration development to management. Perform SQL query design in large-scale data warehouse environments; data integration development using ETL methodology; and data collection and database design using stored procedures, and MPP data warehouse technologies: Teradata, Redshift or Snowflake; and report design using reporting tools including MicroStrategy, Tableau or SSRS. Deliver IT or Business Intelligence (BI) solutions. Query large datasets and tables to provide information requested by business users. Gather detailed business requirements, establish business definitions, translate to technical requirements for development teams, and gain approval. Present data in a fashion that is easy to understand with proper documentation for successful user adoption. Work with cross functional teams to ensure alignment in business needs, timelines, and department standards. Create test plans and scenarios and conduct testing to ensure quality and requirements traceability to final deliverable. Evaluate cross functional and system to system impacts of requirements and change requests. Utilize advanced Excel skills to capture and communicate data findings.
EDUCATION/
REQUIREMENTS: Master’s degree in Information Technology, Computer Science, Electronics Engineering, or a related field. 5 years of experience in: SQL query design in large-scale data warehouse environments; data integration development using ETL methodology; report design using at least one of the following reporting tools: MicroStrategy, Tableau or SSRS; and delivering IT or Business Intelligence (BI) solutions. 4 years of experience in data collection and database design using stored procedures, and at least one of the following MPP data warehouse technologies: Teradata, Redshift or Snowflake. OR Bachelor's degree in Information Technology, Computer Science, Electronics Engineering, or a related field. 7 years of experience in: SQL query design in large-scale data warehouse environments; data integration development using ETL methodology; report design using at least one of the following reporting tools: MicroStrategy, Tableau or SSRS; and delivering IT or Business Intelligence (BI) solutions. 4 years of experience in data collection and database design using stored procedures, and at least one of the following MPP data warehouse technologies: Teradata, Redshift or Snowflake.
Hybrid arrangement is available.
-
-