Senior/Lead Data Engineer

Senior Data EngineerGenerates reports and regular datasets or report information for end-users, using system tools and database or data warehouse queries and scripts. May create specifications for reports based on business requests. Designs, develops and programs methods, processes, and systems to consolidate and analyze structured and unstructured, diverse sources to generate actionable insights and solutions for client services and product enhancement. Analyzes and models data to understand complex business issues and provide insight to decision makers. Integrates data from multiple sources to produce requested or required data elements. Programs and maintains reports, information dashboards, data generators, canned reports and other end-user information portals or resources. Leads enterprise-wide data integration, warehousing and modeling activities across platforms. Uses best practices in data engineering, data warehouse development and integration with enterprise systems.Key responsibilities include:Analyzes data from multiple sources and negotiates differences in storage schema using the ETL processResearches, troubleshoots and resolves data issues impacting extract deliveryDisplays deep understanding of requirements regarding solutions, ensures data quality and match-back to core systems transaction resultsIdentifies and documents process for building data models within a single complex area of Ameren's business (e.g., Distribution Control Center, Transmission, Gas Supply)Assembles large and complex data sets; develops data models based on specifications using structured data setsDevelops familiarity with emerging and complex automations and technologies that support business processesCollaborates with Data Scientists to ensure architectural and project specification needs are being metConducts necessary data transformations to populate data into a warehouse table structure that is optimized for reportingIsolates and defines core reusable data assets that support the long-term business strategy for development effortsReviews data analysis and data mapping logic; identifies recurring causes for defects and works proactively to resolve issues; reviews fixes with the data governance teamsManages delivery of projects in partnership with business stakeholders by demonstrating a deep understanding of the business needs and how technical analysis can produce solutionsTranslates complex business requirements and technical designs into modeling/warehousing solutions aligned to business goals that deliver measurable value to the organizationDesigns and develops data models that provide solutions to business problems in alignment with enterprise architecture direction and design standardsUnderstands the Digital organization's objectives, and the impact on own projects; contributes to development of new data engineering strategiesReaches across multiple functions to implement the models into production and monitors their performanceDemonstrates strong working knowledge of agile software development processes and the development lifecycle; liaises with scrum masters and coaches to move projects forwardCoaches less experienced co-workers and provides feedback to enhance skills and knowledgeQualifications:Bachelor's degree required, preferably in mathematics, statistics, computer science or business5+ years of relevant experience requiredIn addition to the above qualifications, the successful candidate will demonstrate:Strong knowledge and experience in building and optimizing data pipelines, architectures, and datasets from structured datasetsStrong knowledge of data organization and design principles for enterprise data warehouses (EDW), data marts and data lakesDemonstrated ability to build processes that support data transformation, structures, metadata, accuracy checking and workload managementStrong knowledge of cloud architectureStrong knowledge of big data querying toolsStrong understanding of agile and project methodologies and processesStrong analytical and creative thinking to address complex business problems