Data Architect

Architect, Business Intelligence, Engineering, SQL
Full Time

Job Description

Onebridge is seeking a full-time Data Architect to join our growing Data Analytics Practice on-site in Indianapolis supporting a range of leading clients and industry verticals.

Hear from our Business Intelligence Leadership Now!

Data Architect | Overview

The Data Architect will serve a key role within our Data Practice, working with clients to develop end-to-end data-driven solutions. Must be highly analytical and have the proven ability to develop and reverse engineer complex solutions. Critical thinking and advanced problem-solving skills are core behaviors among the team. Strong team and project lead experience will be valuable for this role.

Data Architect | Core Responsibilities

  • Participates in the workstream planning process including inception, technical design, development, testing, and delivery of end-to-end BI solutions
  • Designs, develops and tests databases, data warehouses, data lakes, queries and views, reports, and dashboards
  • Performs data conversions, imports, and exports of data within and between internal and external software systems
  • Merges BI platforms with enterprise systems and applications
  • Documents new and existing models, solutions, and implementations

Data Architect | Skills & Experience

  • 10 years of progressive experience with advanced Data Engineering knowledge
  • 4+ years' experience in the role of a Data Architect
  • Experience architecting design and solutions, including the migration planning of existing data and system
  • Must possess expert level SQL skills
  • Possess strong MSBI Stack including SSRS, SSIS, SSAS with advanced T-SQL
  • Expertise in tabular and multidimensional queries (DAX, MDX)
  • Able to quickly visualize data and create dashboards using other tools such as Power BI, Tableau, and Alteryx are preferred
  • Solid understanding of ETL strategies and design, (staging environments, data transformation, change data capture, slowly changing dimensions, etc.), with an eye towards delivering functional and useful solutions in a timely manner
  • Experience creating global solutions and working with Cloud BI tools such as AWS, Azure, or Google Cloud Platform
  • Deeply understands bi-directional MDM
  • Leading teams and projects to completion

Data Architect | Bonus Qualifications

  • Data Factory including data pipelines, pipeline tasks, factory batches, triggers, control flows, and data flows
  • Wrangling Data Flows, Azure Data Share, Azure Databricks
  • PySpark, Spark, Scala, Stream Analytics, HDInsight, and Hadoop
  • Snowflake Cloud DW Experience; including SnowSQL
  • Data Vault 2.0
  • Azure Synapse

100% Employee-Owned & Voted the #1 Best Place to Work in Indiana, 2021.

#DICE
Dice Id : 10120547
Position Id : KuFCXalXjCYz
Originally Posted : 2 months ago
Have a Job? Post it