Work independently. Provide consultation and instruction to internal personnel regarding performance, financial reporting, benchmarking and advanced report development. Develop data models and identify optimal solutions. Develop, facilitate and lead strategic and collaborative cross-functional implementation plans. Demonstrate superior problem-solving skills and serve as the highest-level resource in that area within the organization. Provide strategic direction and subject matter expertise regarding systems, processes and initiatives and follow through from development to full implementation. Prepare and deliver executive reporting and presentations. Mentor and lead assigned work activities of others within the work group, team, or department.
ESSENTIAL JOB FUNCTIONS:
- Design, write, and optimize complex queries spanning multiple data marts and tables to extract, join, and reconcile data from disparate source systems.
- Design and build warehouse tables that serve as accurate, well-structured foundations for downstream reporting and analysis.
- Apply Python to support data transformation, process automation, and analytical workflows.
- Leverage artificial intelligence tools and techniques to enhance the speed, quality, and depth of data analysis and reporting.
- Connect and integrate data from multiple sources to build polished, executive-ready Power BI dashboards.
- Partner with stakeholders across the organization to translate business questions into well-structured data models and visualizations.
- Proactively investigate underlying data to identify trends, anomalies, and opportunities for improvement.