Business Intelligence Senior Analyst, Information Technology
$80,000–$110,000 year
HybridPlano, Texas, United States
Job Summary
Design and develop Power BI dashboards and reports using best practices, including semantic modeling, DAX measures, and Direct query usage. Build and maintain semantic models that support self-service analytics by integrating data from SQL databases and Fabric Data Lake. Partner with business leaders to determine data and reporting needs, translating requirements into actionable KPIs and providing ad-hoc reporting with short deadlines. Automate reporting and pipelines using Python for data engineering, including ETL/ELT workflows, API integration, and processing diverse file formats. Define and own the enterprise analytics architecture while establishing performance-oriented data modeling practices and optimizing workspace strategies.
Required Qualifications
- Bachelor's degree
- 3 years minimum equivalent experience in Data Analytics and executive level dashboarding
- Python skills for articulating data engineering required for analytics
- Experience with data ingestion, transformation, automation, working with REST APIs, and building pipelines
- The ability to work with multiple groups from both business and technology
- The demonstrated ability to synthesize clear requirements from user inputs
- The Ability to receive, prioritize and complete tasks from multiple sources with minimal supervision
- Expert knowledge of Excel, including formulas and macros
- A strong desire to learn new technologies and improve your skills
- Comfortable in demonstrating reports and presenting analysis to executives and managers
- General understanding of relational and non-relational databases and SQL queries
- Intense knowledge of cloud architecture and familiar with best design practices
- Must be currently authorized to work in the United States on a full-time basis
- Must not require sponsorship for employment visa status now or in the future
- Must be located within reasonable commuting distance of the Plano, TX office
- Must be willing to work in-office on a regular basis (at least 3 days per week)
- Ability to effectively communicate with both business and technical leadership
Desired Qualifications
- Experience with Power BI dashboards and reports
- Experience with semantic models
- Experience with DAX measures and calculations
- Experience with Power BI Service (apps, workspaces, RLS, deployment pipelines)
- Statistical analysis and forecasting
- Automation of reporting and pipelines
- Integrate data from SQL Databases and Fabric Data Lake
- Data transformations using Python (pandas, NumPy, scikit‐learn)
- Building and automating ETL/ELT workflows using Python
- Using Python for API integration (requests, aiohttp)
- Processing diverse file formats—including JSON, CSV, Parquet, Delta—via Python
- Optimizing Python code for performance and handling large datasets efficiently
- Define and own the enterprise analytics architecture while building semantic models, data marts, reporting layers
- Establish best data modeling practices which are performance oriented and drive the roadmap for self service analytics
- Architect and deliver executive level dashboards which might include complex DAX measures, composite models and Direct query usage
- Workspace strategy and cost optimization techniques
- Heavy usage of python services that could architect data engineering, statistical modeling and forecasting
- Experience with a language such as R or Python is a plus
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.