Data Engineer II

TECHNOLOGY PARTNERS INC; St. Louis (MN, MO); On-site; Full time

Job summary

An established industry player is looking for a talented Data Engineer II to join their Cloud Data Engineering team. In this role, you will leverage your expertise in enterprise data modeling and analytics to design and implement robust data models using cutting-edge technologies like Databricks and Azure SQL. Collaborating closely with IT and business stakeholders, you will create optimized data architectures that support advanced analytics and reporting needs. This position offers a unique opportunity to make a significant impact on data strategies and governance while working in a dynamic and innovative environment. If you are passionate about data and eager to contribute to transformative projects, this role is perfect for you.

Qualifications

• 3+ years of experience in data modeling and SQL development.
• Strong collaboration skills with IT and business stakeholders.
• Expertise in data governance and security practices.

Responsibilities

• Design and implement enterprise data models using Databricks and Azure SQL.
• Collaborate with teams to optimize data architectures for analytics.
• Ensure compliance with security policies and improve data management.

Skills

Data Analysis

Enterprise Data Modeling

SQL

Data Modeling Methodologies

Collaboration

Data Governance

Communication Skills

Data Profiling

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Tools

Databricks

Azure SQL

PowerDesigner

Erwin

Teradata

PowerBI

SSRS

Job description

Technology Partners is currently seeking a talented Data Engineer II. Do you have experience building conceptual, logical, and physical data models and implementing them using Databricks and Azure SQL?

Let us help you make your next big career move a reality!

What You Will Be Doing:

We are seeking an experienced Data Engineer II with expertise in enterprise data modeling and analytics to join our Cloud Data Engineering team. You will design, develop, and implement enterprise data models using Databricks and Azure SQL technologies to support advanced analytics, reporting, and data science requirements. This role requires collaboration with IT, analytics, and business stakeholders to create optimized, high-performing data models that align with enterprise strategies and analytics goals.

Key Responsibilities:

• Protects our customers, our employees, and our brands by incorporating security and compliance in all decisions; ensures security policy and procedure requirements are met; continuously identifies opportunities for improving security and implements strategies to improve our security posture.
• Provides technical expertise for the planning, analysis, design, implementation, and control of the organization's data.
• Handles complex or critical data management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database design, integration, source-to-target mapping, data modeling, and data rules management (access by roles and geography, data quality/validation rules, measurements).
• Consults with multiple client groups to provide solutions, implementing long-range internal and enterprise data architecture and management strategies.
• Understand and translate business needs into data models supporting long-term enterprise solutions.
• Closely interact with business partners, stakeholders, functional experts, business analysts, other contractors, and engineers to understand the system requirements and architect and design the data model and database schema based on the requirements.
• Collaborate with the Analytics Team to ensure optimized use of Analytics-Specific Data Architectures - striving for efficient, performant footprint.
• Design data models to best support the analytics needs of the business, consistent with data strategy principles.
• Collaborate with IT and analytics team to arrive at a mutually agreeable data model architecture, approve specs, and review/test/audit post-implementation to ensure objectives have been met.

Required Skills & Experience:

• Strong data analysis skills including oral and written communication skills to effectively communicate with IT and business representatives.
• Strong enterprise data modeling expertise.
• Must have 3 or more years of experience using data modeling tools and methodologies.
• Must have 3 or more years of experience writing and tuning complex SQLs, and the ability to analyze and make recommendations on results.
• Expertise in building conceptual data models through to physical data models and DDL/DML generation.
• Knowledge of building data assets that are strategic, trusted, and agile with governance for data accountability and responsibility.
• Working knowledge of modeling data access layers in an enterprise lakehouse environment.
• Must be able to collaborate in a team-oriented environment as well as work independently with direction.
• Well-versed in different data modeling methodologies (3NF, Dimensional, Data Vault).
• Experience with cloud data lake solutions.
• Expertise with cloud data, enterprise data lake, and business intelligence development technologies.
• Must be committed to incorporating security into all decisions and daily job responsibilities.
• Experience using either PowerDesigner or Erwin modeling software.
• Expertise in performing data analysis and data profiling across a diverse set of data.
• Experience working within a medallion architecture.

Desired Skills & Experience:

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Familiarity with tools like Teradata, PowerBI, or SSRS.
• Experience designing data solutions within a medallion architecture.
• Knowledge of cloud lakehouse technologies and advanced BI platforms.

Pay: $50.32 - $71.88 /yr.

We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to provide sponsorship at this time or accept candidates who would require a corp-to-corp agreement.

If this position sounds like you, WE SHOULD TALK!

Your better future is ready, and we want to put the right tools in your hands to get you there. Let's go!

Keywords: Data Engineer, Data Modeling, SQL, PowerDesigner, Erwin, Databricks, Azure SQL, Enterprise Data Lake, Medallion Architecture