Essential Duties and Responsibilities include the following. Other duties may be assigned.
- Create and optimize Power BI data models (star/snowflake schema) for performance and scalability, utilizing best practices for data modeling and DAX calculations.
- Write complex SQL queries to extract, transform, and load (ETL) data from various sources.
- Design, develop, and maintain dashboards and reports that provide actionable insights for business stakeholders.
- Work closely with business stakeholders to understand their analytical needs and translate requirements into effective data visualizations.
- Ensure visualizations follow design and usability best practices, maintaining consistency, clarity, and data integrity.
- Implement row-level security, custom measures, calculated columns, and DAX expressions as needed.
- Monitor and troubleshoot Power BI service issues, including data refreshes and performance tuning.
- Promote and maintain data governance and quality standards across reporting solutions.
- Stay up-to-date with the latest trends and advancements in Power BI and data analytics to continuously improve our reporting capabilities.
Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Professional Skills:- Desire to work in a fast-paced environment.
- Excellent computer skills
- Excellent communication skills
- Ability to multi-task and distinguish high-priority matters
- Excellent reasoning and analytical skills
- Excellent organizational skills.
- Must be self-motivated with a strong ability to prioritize and recognize critical situations that need immediate attention.
- Must be detail-oriented and produce both a high quality and a high volume of work in a timely manner
Education/Experience: - Bachelor's degree in Computer Science, Data Science, Engineering, Business Analytics, or a related field. A Master's degree or relevant certifications is a plus.
- 3+ years of professional experience developing Power BI reports and dashboards in a production environment.
- Advanced proficiency in Power BI Desktop, Power Query, DAX, Tabular Editor, ALM Toolkit, and DAX Studio.
- Strong SQL skills, with the ability to write and optimize complex queries for relational databases.
- Extensive experience with the Power BI Service, including workspace management, dataset scheduling, dataflows & datasets, and sharing reports with stakeholders.
- Strong understanding of data modeling concepts, data schemas, and query optimization techniques.
- Demonstrated understanding of data visualization best practices-able to present complex data in a clear, compelling manner.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
- Excellent attention to detail, problem-solving, and communication skills.
Certificates, Licenses, Registrations: None
Language Ability: Must have good reading, writing and speaking skills to effectively communicate with studios, managers, and co-workers.
Math Ability: Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent, and to develop and interpret charts.
Reasoning Ability: Perform under pressure and/or opposition at times relying on your own independent judgment and knowledge to decide the best directions and solutions.
Computer Skills: Microsoft Outlook, Word, Excel, database software
Supervisory Responsibilities: This position has no direct supervisory responsibilities.
Work Environment: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The noise level in the environment is moderate.
Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job the employee is frequently required to stand; walk; sit and use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl and talk or hear. The vision requirements include: close vision, distance vision, peripheral vision, depth perception and ability to adjust focus. The employee is occasionally required to lift up to 50 pounds.
Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights notice from the Department of Labor.