Data Analyst - Python, SQL & PowerBI

This is for an energy client in Houston, TX, 4 days per week hybrid. Max $85K-$90K 8% incentives & benefits

A data analyst partners with stakeholders to understand business needs, builds and maintains scalable data pipelines and models, and develops dashboards and reporting solutions that support strategic and operational decision-making.

Description for Internal Candidates

A data analyst partners with stakeholders to understand business needs, builds and maintains scalable data pipelines and models, and develops dashboards and reporting solutions that support strategic and operational decision-making.

Responsibilities for Internal Candidates

• Partner with business stakeholders to assess objectives, capture requirements, and translate them into analytics and reporting solutions.
• Design, develop, and maintain dashboards, reports, and self-service datasets using tools such as Power BI, Tableau, or similar platforms.
• Define and operationalize KPI definitions, calculations, and business rules; document metrics and data lineage for transparency and reuse.
• Perform exploratory analysis to identify trends, patterns, anomalies, and opportunities; communicate findings through clear storytelling and data visualization.
• Provide end-user support and enablement (training, documentation, office hours) to improve adoption and data literacy.
• Design, build, and maintain scalable ETL/ELT pipelines (batch and/or streaming) to ingest, transform, and curate data for analytics and operational use cases.
• Develop and optimize data models (dimensional models, lakehouse/warehouse schemas) to enable performant reporting and consistent analytics.
• Implement data quality checks, monitoring, and automated validation to ensure accuracy, completeness, and timeliness of datasets.
• Troubleshoot and resolve data issues across source systems, pipelines, and semantic/reporting layers; perform root-cause analysis and implement preventive controls.

Qualifications for Internal Candidates

• Bachelor’s degree in computer science, information systems, engineering, analytics, or a related field (or equivalent practical experience).
• 3 years of experience across BI/reporting and data engineering (or demonstrated ability to deliver end-to-end data-to-dashboard solutions).
• Strong SQL skills, including complex joins, window functions, query optimization, and working with relational databases.
• Experience building dashboards and semantic models in a BI platform (e.g., Power BI, Tableau, Qlik) and translating business requirements into reporting solutions.
• Hands-on experience building data pipelines using Python and/or Spark/PySpark, including data transformation and orchestration concepts.
• Working knowledge of data modeling (dimensional modeling, star/snowflake schemas) and BI best practices.
• Strong communication skills with the ability to explain technical topics to non-technical stakeholders.