BI Developer

TechDigital Group; Arden Hills (MN); On-site; USD 90,000 - 150,000; Full time

Job summary

An established industry player is seeking a seasoned Data Architect to lead the design and implementation of data warehouse solutions. In this pivotal role, you will leverage your extensive experience with OBIEE, Informatica, and Snowflake to develop a robust data strategy and roadmap for modern data architecture. You will be responsible for collaborating with cross-functional teams to enhance data quality and integration processes while ensuring the scalability and performance of data systems. If you are passionate about data and eager to make a significant impact in a dynamic environment, this opportunity is perfect for you.

Qualifications

• 7+ years' experience in Data modelling and Business Architecture.
• Experience with Cloud data warehouse solutions like Snowflake.

Responsibilities

• Design and maintain databases, data models, and ETL processes.
• Collaborate with teams to implement metrics, KPIs, and data visualization.

Skills

Data Modelling

Business Architecture

Data Warehouse Solutions

Data Strategy

Cloud Platforms

ETL Processes

Data Quality

Data Integration

Python

SQL

Tools

OBIEE

Informatica

Snowflake

AWS Redshift

Azure Synapse

Google BigQuery

Job description

Mandatory Skills: OBIEE, Informatica, Snowflake.

• 7+ years' experience in Data modelling, Business Architecture and developing Data warehouse solutions on OBIEE, Informatica, Snowflake environments.
• Experience with setting up a Data strategy and roadmap for modern data architecture and migration to Cloud platforms.
• Analyze requirements to create technical designs, data models and migration strategies.
• Interact closely with Business Analysis team, ETL team and BI Reporting teams to ensure understanding of proper use of data architecture.
• Design, build, and maintain physical databases, dimensional data models, ETL layer design and data integration strategies.
• Collaborate with technology stakeholders to define and implement actionable metrics, KPIs and data visualization.
• Implement data quality, data integrity, and data standardization efforts across products and databases enabling key business processes and applications.
• Recommend improvements to enhance existing ETL and data integration processes to enable performance and overall scalability with cross functional teams.
• Experience in working with Cloud data warehouse like Snowflake, AWS Redshift, Azure Synapse or Google BigQuery.
• Hands on experience with programming languages such as Python, SQL to create automated processes for data gathering, cleansing, reporting, and visualization.