Data Analyst

Connect Consulting; Mission (KS); On-site; USD 110,000 - 150,000; Full time

Job summary

Connect Consulting is seeking a BI & Data Analyst Expert to lead a banking transformation initiative, modernizing the BI ecosystem from SAS/SQL/Alteryx to a Power BI platform integrated with Dynamics 365. You will guide strategy, architecture, and governance across Sales, Metiers, and Leadership teams.

The role emphasizes data modeling, ETL/ELT optimization, and upskilling the analytics team to deliver scalable, compliant insights. English fluency and banking domain experience are required.

Qualifications

• 5+ years of BI/Data engineering experience, preferably in banking transformation.
• Strong analytical mindset and ability to translate business needs into data solutions.
• Fluent English and at least one local language.
• Experience guiding teams through technical transitions while ensuring adoption.

Responsibilities

• Lead end-to-end banking data transformations and migrate to Power BI-centric architectures.
• Design scalable Power BI architecture and mentor the team in best practices and deployment pipelines.
• Translate business requirements into optimized data models and analytics frameworks.
• Own ETL/ELT pipelines with emphasis on data quality and governance.
• Document workflows, metadata, and naming conventions for auditability.

Skills

Power BI

Data modeling

ETL/ELT

Team leadership

Strategic thinking

Education

Master's degree

Tools

Alteryx

SAS

SQL

Denodo VQL

Azure Data Factory

Job description

BI & Data Analyst Expert

We’re seeking a visionary BI & Data Analyst / Engineering Expert with a proven track record in banking transformation to lead a high-impact digital evolution. If you thrive at the intersection of business strategy, cutting-edge analytics, and technical innovation, this is your opportunity to redefine how data drives decisions for Corporate Banking’s Sales, Metiers, and Leadership teams.

Your Mission: From Legacy to Leadership

Under the (Cluster) Product owner’s guidance, you’ll spearhead the end-to-end modernization of our BI and reporting ecosystem - transitioning from SAS/SQL, Alteryx, and JavaScript/React to a future-proof Power BI platform integrated with Microsoft Dynamics 365.

It’s a strategic reinvention of how data flows, insights are delivered, and business value is unlocked.

What We’re Looking For

• A seasoned BI & Data Engineering expert with deep banking transformation experience.
• A strategic thinker who can assess legacy systems, data flows, and business needs—contributing to architecting a scalable, future-ready solution.
• A change agent who excels in guiding teams through technical transitions while ensuring business continuity and adoption.
• A collaborative leader who bridges the gap between technical execution and business vision.

Function description

1. Strategic Banking Transformation (ETL & visualisation modernisation)

• Lead end-to-end banking data transformations, with a focus on strategic planning and migration from legacy ETL workflows to Power BI-centric architectures.
• Drive adoption roadmaps for scalable, future-proof BI solutions, ensuring alignment with enterprise data governance and regulatory requirements.

2. Power BI Architecture & Team Upskilling

• Design and enforce a scalable Power BI architecture, including:
  • Coaching & mentoring team members to adopt Power BI best practices (e.g., performance optimization, security, deployment strategies).
  • Upskilling teams in advanced DAX development (complex calculations, time intelligence, dynamic measures) and Power Query/M (efficient data transformation, custom functions).
  • Promoting reusable templates, standardized patterns, and collaborative development (e.g., shared datasets, Power BI Premium capacities).

3. Data Modeling & Analytical Framework

• Translate business requirements into optimized data models for analytics and reporting, including:
  • Dimensional modeling (star/snowflake schemas) simplify cross-platform complexity.
  • Logical/physical data layer design ensuring performance, scalability, and maintainability.
  • Metadata management for traceability (lineage, ownership, refresh cycles).

4. ETL Pipeline & Data Integration

• Own source-to-target mapping and ETL/ELT pipeline optimization, with expertise in:
  • SAS, SQL, Denodo VQL for high-performance data extraction, transformation, and loading.
  • Data quality controls (validation rules, anomaly detection, reconciliation processes).
  • Seamless integration of new data sources with minimal latency and maximum reliability.

5. Documentation & Governance

• Establish and enforce documentation standards for:
  • Datasets (business definitions, technical specifications, refresh policies).
  • Workflows (ETL logic, Power BI reports, dependency mappings).
  • Naming conventions and metadata tagging to ensure discoverability, reusability, and auditability across teams.

6. Testing, Validation & Technical Debt reduction

• Orchestrate coexistence between legacy systems and new Power BI ecosystems during transition phases.
• Develop reusable transformation patterns and consistent business logic across workflows to minimize technical debt.
• Design test cases, validate outputs with stakeholders, and document changes for traceability.
• Proactively identify and remediate performance bottlenecks, data inconsistencies, or integration gaps.

Language requirements

• Fluent knowledge of English as well as (at least) one local language

Education

Master or equivalent experience

Strong analytical mindset

Required experience / knowledge

• At least 5 years of relevant experience

Technical experience mandatory

• Power BI stack : Advanced: DAX, Power Query/M, Premium capacities, deployment pipelines, XMLA endpoints SQL language
• Data modeling : Star/snowflake schemas, dimensional modeling, Power BI dataflows
• ETL tools : Alteryx, SAS, SQL, Denodo VQL, SSIS (legacy), Azure Data Factory (plus)