Lead Data Architect/Developer

Elan Partners; Dallas (TX); On-site; USD 130,000 - 180,000; Full time

Job summary

A leading technology firm is seeking a talented Lead Innovative Solutions professional to optimize their SQL Server and architect a new Azure data platform. This role involves collaborating with cross-functional teams while ensuring system reliability and performance. Ideal candidates will have extensive experience in data engineering, especially with Microsoft technologies.

Benefits

Comprehensive Benefits

Qualifications

• 7+ years of experience in data engineering, data development, or database administration.
• Proven experience with Microsoft Azure data services.
• Strong understanding of data governance and compliance best practices.

Responsibilities

• Support and maintain the existing SQL Server 2017 environment.
• Design and implement data solutions in Microsoft Azure.
• Develop and optimize ETL/ELT processes and data pipelines.

Skills

Data engineering

Data modeling

SQL Server performance tuning

Data integration

Cloud architecture

Power BI

T-SQL

Python

Education

Bachelor's degree in Computer Science

Job description

Direct message the job poster from Elan Partners

Direct Hire Opportunity

No Sponsorship

Onsite

We are looking for a talented Lead innovative solutions. Your immediate focus will be optimizing our SQL Server 2017 environment to ensure robust performance and reliability for business operations. Concurrently, you'll help architect and build our next-generation Azure data platform, encompassing data architecture, integration, and innovative solutions. This position offers the chance to work with diverse technologies, collaborate with cross-functional teams, and shape the future of our data ecosystem while ensuring the stability of current systems. This role requires you to have strong communication skills with focus on your ability to articulate technical concepts to a non-technical person as needed.

Requirements:

• 7+ years of experience in data engineering, data development, or database administration roles.
• 3+ years of experience working with Microsoft Azure data services, including Azure SQL, Data Factory, Synapse, or equivalent.
• Strong understanding of data modeling
• Strong background in SQL Server, including performance tuning, stored procedures, and database design.
• Proven experience developing and maintaining Power BI dashboards and data models.
• Development experience using Microsoft T-SQL, Power BI, SSRS, SSIS, Python and API technologies
• Hands-on experience with data integration tools and building ETL/ELT pipelines.
• Experience supporting and modernizing legacy data systems while transitioning to cloud-based platforms.
• Exposure to different database management systems, including RDBMS system (e.g. PostgreSQL), NoSQL technologies, and columnar databases, with a willingness to deepen expertise as needed.
• Familiarity with data governance, security, and compliance best practices in cloud environments.
• Experience working in cross-functional teams and translating business requirements into technical solutions.
• Background in Construction, Single Family, Multi-Family, and/or Commercial Property Management and/or Accounting is a plus but not required
• Familiarity with CI/CD practices and tools (e.g., Azure DevOps) for deploying data pipelines, infrastructure as code, and analytics solutions.
• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field preferred

Responsibilities

• Support and maintain the existing SQL Server 2017 environment, ensuring data availability, performance, and reliability for ongoing business operations.
• Design and implement scalable, secure, and efficient data solutions in Microsoft Azure, including Azure SQL, Data Factory, Synapse, and related services.
• Develop and optimize data pipelines, ETL/ELT processes, and integrations between systems using modern tools and best practices.
• Build and maintain Power BI dashboards and data models to support business intelligence and reporting needs.
• Collaborate with cross-functional teams to gather requirements, understand data needs, and deliver effective solutions.
• Ensure data quality, security, and governance across both legacy and modern data platforms.
• Document data architecture, processes, and workflows to support maintainability and knowledge sharing.
• Monitor and troubleshoot data systems and integrations, proactively identifying and resolving issues.
• Contribute to the planning and execution of the data platform migration strategy, balancing short-term support with long-term transformation goals.
• Stay current with industry trends and Azure technologies, recommending improvements and innovations where appropriate.
• Understand, debug and troubleshoot SQL, SQL Server databases, Python code and APIs

Comprehensive Benefits are provided

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Technology, Information and Media

Referrals increase your chances of interviewing at Elan Partners by 2x

Sign in to set job alerts for “Data Architect” roles.

Solutions Architect, Retail, Google Cloud

Addison, TX $147,000.00-$216,000.00 5 days ago

Irving, TX $156,160.00-$234,240.00 1 week ago

Senior Clinical Informatics Data Architect

Dallas, TX $134,000.00-$190,000.00 1 day ago

Principal AWS Data Architect and Engineer

Head of Data(Data Architect) : Full-Time

Data Architect with Investment Management experience

Senior Clinical Informatics Data Architect

Dallas, TX $134,000.00-$190,000.00 2 months ago

Data Architect / Data Analyst ( experience in Hadoop required)

Irving, TX $140,000.00-$160,000.00 1 day ago

Irving, TX $106,000.00-$145,000.00 5 days ago

Data Solutions Architect – Federal Program

Irving, TX $119,765.00-$154,990.00 2 days ago

Addison, TX $125,000.00-$178,000.00 2 days ago

Manager, Enterprise Cloud Architecture (Azure)

Irving, TX $125,760.00-$188,640.00 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.