Lead Data Architect/Developer

Paladin Consulting; Dallas (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Paladin Consulting is seeking a Lead Data Architect / Developer to enhance its data infrastructure and implement a cloud-based platform in Dallas, TX. The ideal candidate will possess 7+ years of data experience, especially in Azure, and will be responsible for supporting SQL environments and designing scalable data solutions.

Qualifications

• 7+ years of experience in data engineering, development, or database roles.
• 3+ years with Microsoft Azure services like SQL and Data Factory.
• Experience in building data pipelines and Power BI dashboards.

Responsibilities

• Support and maintain SQL Server environment ensuring data availability.
• Design and implement data solutions in Microsoft Azure.
• Collaborate with teams to gather requirements and develop solutions.

Skills

Data Modeling

SQL Server

Data Governance

Communication

Analytical Skills

Problem Solving

Education

Bachelor's degree in Computer Science

Master's degree (preferred)

Tools

Microsoft Azure

Power BI

Python

T-SQL

SSRS

SSIS

Job description

Paladin Consulting is currently hiring a Lead Data Architect / Developer to join our team working onsite at our client's office located in Dallas, TX.

We work with companies that offer environments for our employees to contribute, learn, and advance their career. We treat you like you are part of the family.

Job Title: Lead Data Architect / Developer
Work Location: Dallas, TX (ONSITE)
Direct Hire
Education/Experience Required: 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.

Job Description :

• We are seeking a highly skilled and versatile Lead Data Architect / Developer to support and enhance our current data infrastructure while helping to design and implement a modern, cloud-based data platform.
• This role is ideal for a technically strong professional who enjoys both maintaining mission-critical systems and building innovative solutions from the ground up. In the near term, you will play a key role in supporting and optimizing our existing SQL Server 2017 environment, ensuring stability and performance for ongoing business operations.
• Simultaneously, you will contribute to the planning and development of our next-generation data platform in Microsoft Azure, including data architecture, integration, and reporting solutions.
• This position offers the opportunity to work across a wide range of technologies, collaborate with cross-functional teams, and help shape the future of our data ecosystem—while ensuring continuity and reliability of our current systems.
• Must have strong communication skills as you will be working with other departments to achieve your milestones. Ability to articulate technical concepts to a non-technical person is 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

Skills & Qualifications : Education and/or Experience

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field (Master's degree preferred).
• 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
• Familiarity with CI/CD practices and tools (e.g., Azure DevOps) for deploying data pipelines, infrastructure as code, and analytics solutions.

Skills/Specialized Knowledge

• Excellent communication, time management and organizational skills
• Solid understanding of data structures and design patterns
• Strong analytical and problem-solving skills
• Ability to work in a deadline driver fast paced environment and handle multiple projects simultaneously with a high level of autonomy while being a team player
• Willingness and ability to learn and research independently
• Sense of Urgency of delivery and ownership of work products

For more information or to view other opportunities, visit us at www.paladininc.com.

Paladin Consulting is an EEOC employer.