Data Analyst
- Minneapolis, MN
- $70,000-110,000 per year
- Permanent
- Full-time
Employment Type: Full-Time | Long-Term
Location: Hybrid from the South area of Minneapolis.
Time Zone: The client operates in the ET time zone.
Industry: Airport ManagementAt Kopius, we are seeking a Data Analyst to join our team! The project operates in the Airport Management sector and is based in Romulus, MI. This organization oversees airport facilities and operations, providing safe, efficient, and reliable air travel services.About the role We are seeking a Power BI Data Analyst to design and build real-time and near real-time dashboards that complete situational awareness capability. This contractor will transform curated Delta Lake data-queried via Azure Synapse serverless SQL pools or Azure SQL-into compelling, actionable visuals hosted in the Power BI GCC (Government Cloud) environment. The analyst must pair advanced SQL and DAX skills with solid dashboard design expertise, operate within GCC constraints, and collaborate closely with the Operations team to turn requirements into user-focused reports.Responsibilities:
- Create new Power BI dashboards and reports that surface KPIs, alerts, and trends for airport operations and leadership.
- Use appropriate visuals (tables, cards, gauges, maps via ArcGIS visuals, etc.) to communicate status and drive decisions.
- Implement DirectQuery connections, push/streaming datasets, or incremental refresh to achieve real-time or near real-time updates.
- Optimize models for performance and data freshness within GCC limits.
- Build efficient semantic models in Power BI Desktop; author complex DAX measures (time intelligence, rolling metrics, conditional alerts) to meet business logic.
- Ensure models follow star-schema best practices.
- Write and tune SQL against Synapse serverless SQL pools and Azure SQL to shape datasets, create views, and validate data before import.
- Work with Data Engineers to request or create curated views when needed.
- Gather and refine dashboard requirements with Operations stakeholders.
- Iterate on prototypes, incorporate feedback, and document report logic and usage.
- Validate data accuracy before publishing; reconcile discrepancies by tracing back to curated sources and coordinating with engineers or MDM stewards.
- Work with data architect to configure gateways, data sources, and workspace settings for GCC Low. Address feature gaps (e.g., no Fabric) by selecting supported alternatives.
- Self-motivated, quick learner, and adaptable to new technologies and legacy systems.
- 3+ years building enterprise dashboards with Power BI (Desktop & Service).
- Expert-level DAX and Power Query (M); deep experience optimizing models for performance.
- Advanced T-SQL skills for query design, tuning, and data validation.
- Demonstrated success delivering real-time or streaming Power BI solutions (DirectQuery, push datasets, or Stream Analytics output).
- Familiarity with Azure Synapse serverless SQL pools, Delta Lake tables, and Azure SQL.
- Strong data visualization and UI/UX instincts; ability to translate operational scenarios into clear visuals.
- Experience operating in Microsoft GCC or other government/regulated cloud a strong plus.
- Power BI Data Analyst Associate (PL-300) or Azure Enterprise Data Analyst (DP-500).
- Exposure to geospatial visuals or ArcGIS for Power BI.
- Understanding of metadata-driven data lakehouse architectures and medallion patterns.
- Applicants should be eligible to work in the US without requiring sponsorship.
- This is a full-time, long-term and hybrid opportunity from the US.
- This role is will share time between billable projects and internal solution and innovation work and will heavy communication customers.
- Pay range: $70,000- $110,000 anually. Individual pay is determined by multiple factors, including job-related knowledge, skills, experience, and relevant education or training.
- Flex PTO, plus 11 paid holidays!
- 12 weeks paid Parental Leave.
- Flexible working hours!
- Fully paid medical/dental/vision benefits for you and your family
- Numerous company and team building events.
- Professional Development Fund for continuing education and training!
- Short & Long-Term Disability fully paid for Life Insurance.
- 401(k)- with employer matching up to 4% of salary contributions.
- Community and Connection: Foster team connection; contribute to a collaborative environment.
- Exceptional Experiences: Strive for outstanding communication experiences; align actions with delivering excellence.
- Embrace New Ideas: Demonstrate openness to innovation; adapt and learn quickly.
- Ownership Mentality: Take responsibility and ownership of tasks and projects; drive issues to resolution.
- Walk the Talk: Consistently align actions, communication, and problem-solving with company values.