At Alliants, we're on a mission to transform every customer engagement into something exceptional. We believe in working smart together to push the boundaries of company culture and create future-proof customer experiences. This contract role is focused on the operational stability, maintenance, and enhancement of their existing data platform and Business Intelligence (BI) solutions.
Requirements
- Expert-level SQL proficiency is mandatory, with demonstrable experience writing complex queries, stored procedures, and transformations across various database systems including SQL Server, Oracle, and Azure Synapse Analytics.
- Deep expertise in Power BI, including advanced DAX for complex measures, data modeling (star schemas) within Power BI, performance tuning, and administration of workspaces and security.
- Hands-on experience maintaining and troubleshooting data pipelines, specifically using Azure Data Factory (ADF).
- Proven experience working in a hybrid data environment, comfortably querying and extracting data from both on-premise relational databases (Oracle, SQL Server) and cloud data platforms.
- Scripting ability in Python or PowerShell for automation or data manipulation tasks.
- Understanding of version control with Git.
- Relevant cloud certification (e.g., Azure Data Engineer Associate, AWS Certified Data Analytics).
Responsibilities
- Serve as the subject matter expert for the client's Power BI environment, providing hands-on support to business users.
- Troubleshoot and optimize existing Power BI reports and dashboards, diagnosing performance bottlenecks, correcting data inaccuracies, and refining DAX calculations.
- Translate business user requests into effective ad-hoc queries and minor enhancements to existing data models to support their analytical needs.
- Manage Power BI user permissions, workspaces, and access controls.
- Monitor and maintain existing data ingestion pipelines, ensuring data flows reliably from source systems (including Oracle, SQL Server, Workday) into their destinations (Azure, Snowflake etc.).
- Diagnose and resolve failures or data quality issues within existing data pipelines and databases, performing root cause analysis to prevent recurrence.
- Perform routine maintenance, optimization, and incident response for the client’s production data environment across both Azure and legacy systems.
Other
- 5+ years of experience in analytics engineering, BI development, or a similar data-focused role.
- Strong client-facing communication skills, with experience supporting non-technical business users and translating their needs into technical actions.
- Experience with data in a healthcare, senior living, or other regulated industry (e.g., familiarity with HIPAA or similar data privacy concerns).
- Familiarity with ticketing and workflow systems like ServiceNow.
- A true service-oriented mindset, viewing business users as your primary customers and being driven to resolve their issues.
