About this role
ESSENTIAL DUTIES AND RESPONSIBILITIES:
- Collect, clean, integrate, and analyze structured and unstructured data from multiple business systems using SQL, Python, Power Query, or other approved tools.
- Create and publish dashboards, reports, scorecards, semantic models, and presentations using Power BI, Excel, and other approved visualization tools.
- Apply AI-assisted analytics tools, including Copilot features and approved generative AI capabilities, to accelerate data exploration, documentation, insight generation, and report development.
- Identify trends, patterns, anomalies, and business drivers, then translate findings into clear recommendations for technical and nontechnical audiences.
- Partner with business users to understand objectives, define data requirements, document business rules, and translate needs into technical specifications and analytical solutions.
- Develop and maintain reusable data pipelines, dimensional models, semantic models, calculations, and data quality controls.
- Validate data accuracy, test solutions, troubleshoot issues, reconcile results, and document assumptions, lineage, definitions, and limitations.
- Explore practical AI and machine learning use cases, assist with prototypes, and evaluate results against business value, data quality, security, privacy, and responsible AI expectations.
- Support data migrations, system interfaces, and modernization initiatives involving on-premises and cloud data platforms.
- Review current processes and recommend opportunities for automation, standardization, self-service analytics, and improved user experience.
- Stay current on analytics, Microsoft Fabric, Power BI, AI, data governance, and visualization best practices.
- Other duties and responsibilities as assigned and required.
EDUCATION, TRAINING, AND EXPERIENCE:
- Bachelor's degree from a four-year university in data analytics, computer science, information systems, statistics, business, or a related field desired.
- Two or more years of related experience in data analysis, analytics, business intelligence, reporting, or data administration desired.
- Hands-on experience with data visualization, data modeling, data preparation, and data quality practices.
- Exposure to cloud analytics platforms, Microsoft Fabric, Azure data services, AI-assisted analytics, or machine learning concepts desired.
REQUIRED SKILLS:
- Strong analytical problem-solving skills with the ability to connect data findings to business outcomes.
- Ability to work independently under general supervision while collaborating effectively with business and technical stakeholders.
- Ability to plan and prioritize work, manage multiple assignments, and meet deadlines in a changing environment.
- Strong written, verbal, presentation, and data storytelling skills.
- Ability to translate complex technical concepts into clear business language.
- Attention to detail and commitment to data accuracy, documentation, reproducibility, and continuous improvement.
- Ability to adhere to confidentiality, information security, privacy, data governance, and responsible AI standards.
- Curiosity and willingness to learn emerging data and AI technologies.
TOOLS, EQUIPMENT, AND SOFTWARE:
- Required: SQL, Microsoft SQL Server, Power BI, DAX, Power Query, and Excel.
- Desired: Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory, Dataflow Gen2, notebooks, semantic models, and Direct Lake.
- Desired: Python or R for data analysis, automation, statistical analysis, or machine learning.
- Desired: ETL or ELT development, source control, deployment pipelines, data cataloging, and data lineage practices.
- Desired: Experience using Copilot or other approved AI tools for analytics, while validating outputs and protecting confidential data.
- Desired: Use Microsoft Fabric capabilities such as OneLake, Lakehouse, Warehouse, Data Factory, notebooks, data pipelines, Dataflow Gen2, and Direct Lake where appropriate
WORKING CONDITIONS AND PHYSICAL REQUIREMENTS:
- Primarily indoor work in an office environment requiring long periods of sitting
- Frequent utilization of manual dexterity and visualizing of a computer screen
- No unusual physical requirements