The Railroad Commission of Texas requires the services of one (1) Senior Business Intelligence Analyst, Level 3, with strong experience in Power BI and Snowflake to transform raw data into actionable insights. This role blends technical expertise, analytical thinking, and business acumen to support data‑driven decision‑making across the organization. Additionally, focus on technical development, data modeling, stakeholder partnership, and enablement through training and self‑service analytics frameworks.
All work products resulting from the project shall be considered works made for hire and are the property of the Railroad Commission of Texas. Background checks may apply as authorized by Texas law. RRC will pay no fees for interviews or discussions during Candidate selection.
Job Description
Major responsibilities include Design, build, and maintain Power BI dashboards, reports, and semantic models using Power Query, and best‑practice data modeling. Develop scalable star‑schema models and reusable datasets to support enterprise reporting. Ensure visualizations are intuitive, accurate, and aligned with business needs. Analyze complex datasets to identify trends, patterns, and opportunities for business improvement.
Other responsibilities include working closely with business stakeholders to gather requirements and translating them into BI solutions. Present insights and recommendations to leadership in a clear, compelling way. Support self‑service analytics by enabling business users to explore curated datasets.
Essential Job Duties
- Implement BI best practices, including version control, documentation, and data governance.
- Optimize Power BI datasets for performance, scalability, and cost efficiency.
- Partner with data engineering teams to refine Snowflake schemas, pipelines, and performance.
- Partner with report data architect to curate, certified datasets, data dictionaries and business glossaries.
- Validate data quality and ensure consistency across all BI assets.
- Support the governance standards for dataset ownership and lifecycle, access models and role‑based permissions.
- Establish best practices for dataset usage, report creation, and data stewardship.
- Monitor adoption and continuously improve the self‑service ecosystem.
- Develop and deliver train‑the‑trainer programs to empower power users, analysts, and business champions.
- Create training materials, documentation, and hands‑on workshops for Power BI and Snowflake‑based data sources.
- Mentor business teams on interpreting insights, building reports, and applying data‑driven decision‑making.
II. CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. |
Years | Required/Preferred | Experience |
10+ | Required | Experience in BI, analytics, or data modeling roles. |
5+ | Required | Advanced proficiency with Power BI (DAX, Power Query, data modeling). |
5+ | Required | Skill with Microsoft Office tools, particularly with Word, Excel, PowerPoint, Visio, and SharePoint |
3+ | Required | Strong SQL skills with hands‑on experience in Snowflake, Databricks, or similar product. |
5+ | Required | Experience designing or supporting self‑service analytics environments. |
2+ | Preferred | Knowledge of database structures and theories |
2+ | Required | Knowledge of enterprise information management processes and methodologies, relational database management systems, and metadata management |
2+ | Preferred | Knowledge of local, state, and federal laws and regulations (PII) relevant to data management and data governance |
2+ | Required | Experience in working in fast-paced and ever-changing environments; achieving project’s deliverables and deadlines; exercising sound judgment in making critical decisions; analyzing complex information and developing plans to address identified issues. |
2 | Required | Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various levels of personnel. |
2+ | Preferred | Experience in data focused projects, like moving from Legacy to newer systems. |
- | Preferred | Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field. |
Never miss an opportunity! Create an alert based on the job you applied for.