Senior Data Analyst

Utilize cloud-based platform to cleanse and blend datasets, build reports and dashboards, create automation workflows, develop data storytelling, and create predictive and machine learning models. Minimum of 5 years of experience writing and troubleshooting SQL queries, including joins, aggregations, subqueries, common table expressions, views, and performance optimization.

Role Overview - Senior Data Analyst 

Join our team in Fort Worth, TX, a vibrant city known for its rich history and dynamic cultural scene. This role offers the flexibility of working from home with occasional visits to the office for training and collaboration.

Key Roles & Responsibilities

• Partner with stakeholders to define reporting, analytics, and Business/Decision Intelligence requirements.
• Write, optimize, validate, and maintain complex SQL queries, tables, and views from Oracle, MS SQL Server, and Exasol databases.
• Develop and maintain data extraction pipelines from Enterprise Data Warehouses into cloud-based platform.
• Perform data validation, root-cause analysis, and reconciliation across source systems.
• Help design, document, standardize, and improve data structures, definitions, and governance practices.
• Utilize cloud-based platform to cleanse and blend datasets, build reports and dashboards, create automation workflows, develop data storytelling, and create predictive and machine learning models.
• Develop training materials, lead workshops, and provide ongoing education to users of cloud-based platform’s reporting and analytics.
• Maintain strong working relationships with internal business partners, technology teams, vendors, and stakeholders.
• Perform other duties as assigned.

Education, Experience & Skills

• Bachelor’s degree in Supply Chain, Logistics, Business Analytics, Information Systems, Data Analytics/Engineering, or a related field is preferred.
• Minimum of 5 years of professional experience in business intelligence, data analytics/engineering/science, or a related analytical role.
• Minimum of 5 years of experience writing and troubleshooting SQL queries, including joins, aggregations, subqueries, common table expressions, views, and performance optimization.
• Minimum of 3 years of hands-on dashboard development, including calculated fields, parameters, filters, data sources, publishing, scheduling, and performance optimization.
• Minimum of 2 years of hands-on data engineering/architecture building, extraction and loading, transformation, modeling, data quality validation, or data automation.
• Utility industry, energy industry, construction, inventory, procurement, or supply chain experience is preferred.
• Strong understanding of data governance, data quality, documentation, access controls, and SOX-compliant reporting practices is preferred.

Core Competencies

• Advanced analytical, problem-solving, and root-cause analysis skills.
• Strong written, verbal, and presentation communication skills, with the ability to explain technical findings to nontechnical audiences.
• Ability to translate business requirements into data models, SQL queries, dashboards, reports, and actionable recommendations.
• Strong attention to detail and commitment to data accuracy, completeness, consistency, and timeliness.
• Ability to manage multiple priorities, deadlines, stakeholders, and projects in a fast-paced environment.
• Demonstrated ability to build consensus, influence outcomes, and collaborate across functional teams.
• Ability to work independently while contributing effectively to a collaborative team environment.
• Ability to facilitate the design, documentation, and reengineering of business processes.

Measures of Success

• All applicable SOX controls, data governance requirements, and reporting controls are established, documented, and consistently followed.
• Data issues are identified, investigated, communicated, and resolved promptly through effective root-cause analysis.
• Technical content is effective, efficient, validated, maintainable, and appropriately documented.
• Functional content for end users is published accurately and timely and provides reliable, usable, and actionable insights for business stakeholders.
• The analyst actively contributes to a collaborative, accountable, and high-performing team environment.

#zr