Performance Data-Engineer

$90,000 - $150,000/Yr

The Morning Star Company - Woodland, CA

posted about 2 months ago

Full-time - Mid Level
Remote - Woodland, CA
1,001-5,000 employees
Crop Production

About the position

The Morning Star Company is seeking a Performance Data Engineer to join our team in either Woodland, CA or Los Banos, CA. This role is integral to our mission of enhancing data-driven insights across the organization. The Performance Data Engineer will be responsible for driving our data strategy, which includes the design, development, and management of enterprise reporting and business intelligence (BI) solutions. The successful candidate will work closely with various stakeholders to understand their business requirements and architect solutions that make data accessible, reliable, and actionable. In this role, you will be tasked with developing, optimizing, and maintaining complex SQL queries and reports to meet the analytical and reporting needs of different stakeholders. You will also be responsible for developing and maintaining the overall BI architecture, which includes data warehouses, ETL processes, OLAP cubes, dashboards, and reporting solutions. Additionally, you will oversee the design and implementation of ETL processes to ensure data quality and consistency across the BI environment. The Performance Data Engineer will also manage API integrations to facilitate seamless data flow between systems and the BI platform. Collaboration with business leaders, analysts, and IT teams is essential to gather requirements and design BI solutions that align with business objectives. Performance optimization of BI systems, including tuning queries and managing the underlying data infrastructure, will be a key responsibility. Furthermore, you will establish and enforce data governance practices to ensure compliance with data security policies and regulations. Documentation and training are also critical components of this role, as you will create and maintain detailed documentation of the BI architecture and provide training and support to end-users. Staying current with industry trends and best practices in BI, data analytics, and API management is essential, as is leading BI projects from inception to completion, including planning, resource allocation, risk management, and delivery.

Responsibilities

  • Develop, optimize, and maintain complex SQL queries and reports to meet analytical and reporting needs.
  • Develop and maintain the overall BI architecture, including data warehouses, ETL processes, OLAP cubes, dashboards, and reporting solutions.
  • Design and oversee ETL processes to integrate data from various sources into the BI environment, ensuring data quality and consistency.
  • Develop and manage API integrations to ensure seamless data flow between systems and the BI platform.
  • Collaborate with business leaders, analysts, and IT teams to gather requirements and design BI solutions that align with business objectives.
  • Optimize the performance of BI systems, including tuning queries, indexing, and managing the underlying data infrastructure.
  • Establish and enforce data governance practices and ensure compliance with data security policies and regulations.
  • Create and maintain detailed documentation of the BI architecture, processes, and systems.
  • Provide training and support to end-users.
  • Stay current with industry trends and best practices in BI, data analytics, and API management.
  • Lead BI projects from inception to completion, including planning, resource allocation, risk management, and delivery.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field; a Master's degree is a plus.
  • 5+ years of experience in BI, data warehousing, and analytics.
  • Proficiency in BI tools such as Power BI.
  • Strong experience with ETL tools (e.g., SSIS, Data Factory) and data modeling.
  • Expertise in SQL and database management (e.g., SQL Server, MySQL).
  • Experience with API development and integration, including RESTful and SOAP APIs.
  • In-depth experience building data pipelines, storage, and processing frameworks.
  • Strong problem-solving and analytical abilities, with a keen understanding of data analytics, reporting, and business processes.
  • Excellent verbal and written communication skills, with the ability to convey complex technical concepts to non-technical stakeholders.
  • Proven leadership experience in guiding teams and managing cross-functional projects.

Nice-to-haves

  • Experience with cloud-based data solutions and platforms.
  • Familiarity with data visualization best practices and tools.
  • Knowledge of machine learning concepts and applications.

Benefits

  • Comprehensive health plan including medical, dental, and vision, with full monthly premiums paid for the Colleague and all eligible family members.
  • Contributions to Colleagues' Health Savings Accounts.
  • 401K plan with 4% match for year-round Colleagues.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service