IT Data Analyst

PTR Global; Houston (TX); On-site; USD 95,000 - 135,000; Full time

Job summary

PTR Global is seeking a Senior Data Analyst to design and own Power BI dashboards that empower business users to make data-driven decisions.

You will partner with stakeholders to define KPIs, build scalable data models from DynamoDB and Postgres, and translate technical data into clear business insights while ensuring performance and self-service analytics.

Qualifications

• Bachelor's degree in Analytics, Data Science or related field
• 5 years of analytics/BI/data analysis experience
• Strong Power BI experience with data modeling and DAX
• Strong SQL skills; experience with PostgreSQL
• Experience with AWS-based data sources
• Ability to translate complex data into business insights

Responsibilities

• Design, build, and own Power BI dashboards and reports for business, product, and operations stakeholders
• Partner with stakeholders to define KPIs and translate business questions into scalable data models and visualizations
• Analyze and model data from DynamoDB and Postgres
• Leverage data from AWS-hosted infrastructure to support reporting and analytics
• Incorporate RUM and APM data into dashboards to surface performance and reliability trends
• Build and maintain advanced DAX measures and calculations following Power BI best practices
• Ensure dashboards are performant, maintainable, and self-serve
• Validate data accuracy and collaborate with engineering to resolve inconsistencies
• Establish best practices for dashboard design, metric definitions, and documentation
• Provide mentorship and technical guidance to other analysts

Skills

Power BI

SQL

Data Modeling

DAX

NoSQL (DynamoDB)

AWS

RUM/APM interpretation

Education

Bachelor's degree in Analytics/Data Science/CS or related field

Tools

PostgreSQL

DynamoDB

Job description

• We are seeking a Senior Data Analyst to lead the development of dashboards and analytics solutions that empower business users to make data driven decisions.
• This role will focus heavily on building high quality Power BI dashboards using data from modern cloud based sources including UDH data sources DynamoDB Postgres and application observability tools RUM and APM platforms.
• You will operate as a trusted analytics partner-owning metrics end to end shaping data standards and translating complex technical and behavioral data into clear business insights.

Key Responsibilities

• Design build and own Power BI dashboards and reports for business product and operational stakeholders
• Partner with stakeholders to define KPIs and translate business questions into scalable data models and visualizations
• Analyze and model data from UDH data sources DynamoDB and Postgres
• Leverage data from AWS hosted infrastructure to support reporting and analytical use cases
• Incorporate Real User Monitoring RUM and Application Performance Monitoring APM data into dashboards to surface trends related to performance reliability and user experience
• Build and maintain advanced DAX measures and calculations following Power BI best practices
• Ensure dashboards are performant maintainable and intuitive for self service consumption
• Validate data accuracy perform root cause analysis and partner with engineering teams to resolve inconsistencies
• Establish best practices for dashboard design metric definitions and documentation
• Provide mentorship and technical guidance to other analysts raising the overall analytics maturity of the team

Required Qualifications

• Bachelors degree in Analytics Data Science Business Computer Science or a related field or equivalent experience
• 5 years of experience in analytics business intelligence or data analysis roles
• Advanced experience with Power BI including data modeling DAX and Power BI Service
• Strong SQL skills and experience querying Postgres or similar relational databases
• Hands on experience working with NoSQL data sources such as DynamoDB
• Experience analyzing data in AWS based environments
• Ability to translate technical or behavioural data e.g. RUM APM into business relevant insights
• Strong communication skills with the ability to present complex insights to non technical audiences

Preferred Qualifications

• Experience working with UDH or unified data hub-style architectures
• Familiarity with RUM and APM tools e.g. application monitoring performance metrics latency errors
• Experience building dashboards for product reliability or customer experience use cases
• Understanding of data governance KPI standardization and self service analytics
• Prior experience serving as a domain owner or analytics lead What Success Looks Like
• Business and product leaders rely on your dashboards to guide decisions
• Performance reliability and usage metrics are clearly defined trusted and widely understood
• Dashboards effectively combine business product and observability data
• You are seen as a strategic thought partner-not just a report builder