Myers Industries - Flower Mound, TX

posted 2 months ago

Full-time
Flower Mound, TX
Primary Metal Manufacturing

About the position

Signature Systems, a Myers Industries company, is seeking a skilled and experienced Business Intelligence (BI) Developer to join our dynamic team in Flower Mound, TX. As a BI Developer, you will play a crucial role in designing, developing, and maintaining business intelligence solutions that provide valuable insights into the organization's data. This position is essential for helping the company make informed decisions based on data analysis and reporting. You will collaborate with business stakeholders, analysts, and other IT professionals to understand requirements, design effective solutions, and ensure the successful implementation of BI projects. In this role, you will be responsible for MS SQL Development, which includes designing and implementing database schemas, writing and optimizing SQL queries, and developing stored procedures, functions, and triggers. You will ensure data quality and consistency while collaborating with application developers to integrate database solutions effectively. Additionally, you will develop and maintain Extract, Transform, Load (ETL) processes to integrate data from various sources into the data warehouse, and design and implement data models to support business intelligence and analytics requirements for the Enterprise Data Warehouse (EDW). Performance optimization is another key responsibility, where you will optimize queries and data processes to ensure efficient and timely access to information. You will work closely with business stakeholders to gather requirements and understand their data and reporting needs. Collaboration with cross-functional teams, including business analysts, database administrators, and IT developers, is essential to deliver comprehensive BI solutions. You will also create and maintain documentation for BI solutions, including technical specifications, user guides, and best practices, and provide training and support to end-users to ensure effective use of BI tools and reports.

Responsibilities

  • Design and implement database schemas using MS SQL (Azure and On Prem).
  • Write and optimize SQL queries, develop stored procedures, functions, and triggers.
  • Ensure data quality and consistency in database solutions.
  • Develop and maintain Extract, Transform, Load (ETL) processes for data integration.
  • Design and implement data models to support business intelligence and analytics requirements.
  • Optimize queries and data processes for efficient information access.
  • Gather requirements from business stakeholders regarding data and reporting needs.
  • Collaborate with cross-functional teams to deliver comprehensive BI solutions.
  • Create and maintain documentation for BI solutions, including technical specifications and user guides.
  • Provide training and support to end-users for effective use of BI tools and reports.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • Proven experience as a BI Developer or similar role.
  • Proficient in SQL, EDW, ETL processes, and data modeling.
  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration abilities.
  • Knowledge of data warehousing concepts and best practices.

Nice-to-haves

  • Complete lifecycle EDW development in MS SQL server.
  • Experience with Business Intelligence concepts and techniques.
  • Experience with cloud-based BI solutions.
  • Experience with BI tools such as Power BI.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service