Why Pretium Enterprise Services? is hiring a Lead Data Analyst to own the design of dashboards, perform in-depth data analysis, and present actionable insights to leadership. This role is central to translating complex data into strategic guidance.
What You'll Do
- Design, develop, and maintain interactive dashboards and reports using Power BI.
- Write optimized SQL queries for data extraction, transformation, and analysis across multiple databases.
- Perform advanced Excel modeling, including pivot tables, Power Query, and VBA (optional).
- Collaborate with cross-functional teams to understand business requirements and translate them into analytical solutions.
- Conduct data profiling, cleansing, and validation to ensure data integrity and accuracy.
- Present insights and recommendations to senior leadership through compelling visualizations and storytelling.
- Monitor KPIs and build automated reporting frameworks to support operational and strategic goals.
- Mentor junior analysts and contribute to analytics best practices and governance.
What We're Looking For
- A Bachelor’s or Master’s degree.
- 6+ years of experience in data analytics or business intelligence roles.
- Expert-level proficiency in Power BI, SQL (T-SQL, PL/SQL), and Microsoft Excel.
- Strong understanding of data warehousing concepts and relational databases.
- Excellent communication and stakeholder management skills.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
Nice to Have
- Experience with cloud data platforms (e.g., Azure, Snowflake, AWS) is a plus.
Technical Stack
- Power BI, SQL, T-SQL, PL/SQL, Microsoft Excel, Power Query, VBA, Azure, Snowflake, AWS
Team & Environment
You will collaborate with cross-functional teams.
