Senior Data Engineer

Job Title: Senior Data Engineer.
Location: St. Louis, MO (On-site).
Employment Type: Contract (W2 through Zip Staff - No C2C or 1099).

About the Opportunity.
Zip Staff is seeking an experienced Senior Data Engineer to support data analysis, reporting, modeling, and insight generation for a major energy and utility organization.

This senior role focuses on designing processes and systems to consolidate and analyze structured and unstructured data from diverse sources, generating actionable insights for client services and product enhancement. You will build reports, dashboards, and data solutions while applying advanced analytical techniques and supporting data science and AI-aligned outcomes.

• Generate reports and regular datasets or report information for end-users using system tools and database or data warehouse queries and scripts; create specifications for reports based on business requests.
• Design, develop, and program methods, processes, and systems to consolidate and analyze structured and unstructured data from diverse sources to generate actionable insights and solutions.
• Analyze and model data to understand complex business issues and provide insight to decision makers.
• Integrate data from multiple sources to produce requested or required data elements.
• Program and maintain reports, information dashboards, data generators, canned reports, and other end-user information portals or resources.
• Use advanced mathematical and statistical concepts and theories to analyze and collect data; identify and interpret trends and patterns in datasets.
• Support complex business problems and issues using unstructured data from internal and external sources to provide insight to decision-makers.
• Build or define machine learning / Artificial Intelligence (AI) solutions that create value for the business.
• Address business problems by applying advanced analytics techniques on big, unstructured data sets.
• Design databases for unstructured data sets, defining how the data will be stored, consumed, integrated, and managed.
• Develop optimal techniques and problem-solve to understand and explore correlations between disparate data sets; coach on how to transform and clean data for statistical analysis.
• Conduct exploratory data analysis from complex data sources and build key data sets.
• Work closely with data analysts and data engineers to review and provide feedback on data pipelines and optimization opportunities.
• Translate complex business requirements and technical designs into data science / artificial intelligence solutions aligned to business goals that deliver measurable value.

• 5+ years of experience as a Data Engineer or in a similar role focused on data analysis, reporting, modeling, and pipeline support.
• Proven experience generating reports and datasets using database or data warehouse queries and scripts.
• Strong skills designing and developing processes and systems to consolidate and analyze structured and unstructured data from diverse sources.
• Experience analyzing and modeling data to provide insights to decision makers.
• Hands-on experience integrating data from multiple sources and programming/maintaining reports, dashboards, and end-user information resources.
• Ability to apply advanced mathematical and statistical concepts to identify trends and patterns.
• Experience working with unstructured data and supporting complex business problems.
• Familiarity with building or defining machine learning / AI solutions that create business value.
• Ability to conduct exploratory data analysis, design databases for unstructured data, and coach on data transformation and cleaning.
• Strong collaboration skills working with data analysts, data engineers, and stakeholders.
• Ability to work…