Data Architect

Full Tilt Data, LLC; United States; On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health benefits

Discretionary bonuses

Professional development reimbursement

Job summary

Full Tilt Data, LLC is seeking a Data Architect to lead enterprise data and integration initiatives for a federal government program. You will guide the design of data models, build scalable AWS-based data lake solutions, and define governance and security practices.

You will manage a team of data professionals, review complex SQL and Python code, coordinate with stakeholders, and ensure compliance with federal security standards while delivering architectural milestones.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 7+ years of experience in data architecture, data engineering, or software engineering.
• Hands-on experience designing data structures and solutions in AWS, including data lake environments.
• Advanced proficiency in SQL and Python, including code review and performance tuning.
• Experience designing and implementing data governance, including cataloging, lineage, data quality, and access controls.
• Experience with ETL/ELT processes, data integration, and API design.
• Demonstrated experience leading technical teams, including supervising direct reports.
• Strong written and verbal communication skills, including presenting technical recommendations to management.
• Candidates must be able to pass a background check equivalent to a Federal Public Trust clearance.

Responsibilities

• Design, build, and refine data structures across all environments, including an AWS-based data lake.
• Create high-level architectural specifications and resolve integration issues across platforms.
• Design and maintain data governance processes, including RBAC and data quality metrics.
• Develop and review complex SQL and Python code and serve as the program's data SME.
• Design and support ETL/ELT pipelines, data streams, APIs, and data intake processes.
• Support analysts in Databricks, managing access and curated datasets.
• Ensure all data processes meet client security and compliance requirements.
• Assess risk and impact of planned system changes.
• Evaluate data needs and vendor options, and build proofs-of-concept solutions.
• Contribute technical content to proposals and guide Agile/SAFe teams.

Skills

SQL

Python

Leadership

Communication

Data governance

Education

Bachelor's degree in Computer Science/Engineering/Information Systems

Tools

Databricks

Spark

PySpark

AWS

Job description

Full Tilt Data, LLC is a trusted data, analytics, and IT consulting firm specializing is health related services for the federal government. Established in 2023 by a group of founders that bring 15+ years of industry experience. We are passionate about harnessing the power of data through our comprehensive data management solutions. We mobilize the right people, skills, and technologies to help all types of organizations and companies improve their performance and data management.

Position Summary

Full Tilt Data, LLC is looking for a Data Architect to help deliver enterprise data and integration solutions for a federal government program. In this role, you will lead a team of data professionals, create high-level architectural specifications, solve systems integration and compatibility challenges, and guide the design and development of new software and major revisions for the customer. You will also research and assess project feasibility and present recommendations to management.

Key Responsibilities

• Design, build, and refine data structures across all supported environments, including an AWS-based data lake, and resolve performance issues.
• Create high-level architectural specifications and resolve systems integration and compatibility issues across platforms, data sources, and interfaces.
• Design and maintain data governance processes, including data catalog, provenance, lineage, data quality metrics, and role-based access control (RBAC).
• Develop and review complex SQL and Python code and serve as the program's data subject matter expert.
• Design and support ETL/ELT pipelines, data streams from multiple sources, APIs, and data intake and submission processes.
• Support analysts and data consumers in Databricks, including creating curated data sets, managing access, and applying tags that enable AI and analytics functionality.
• Ensure all data processes meet client security and compliance requirements.
• Assess the risk and impact of planned system changes, both within and outside the program.
• Evaluate complex data needs and vendor options, and design and build proof-of-concept solutions.
• Contribute technical content to proposals and provide technical direction within Agile/SAFe development teams.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 7+ years of experience in data architecture, data engineering, or software engineering.
• Hands-on experience designing data structures and solutions in AWS, including data lake environments.
• Advanced proficiency in SQL and Python, including code review and performance tuning.
• Experience designing and implementing data governance, including cataloging, lineage, data quality, and access controls.
• Experience with ETL/ELT processes, data integration, and API design.
• Demonstrated experience leading technical teams, including supervising direct reports.
• Strong written and verbal communication skills, including presenting technical recommendations to management.
• Candidates must be able to pass a background check equivalent to a Federal Public Trust clearance.

Preferred Qualifications

• Experience with Databricks, Spark, and PySpark, including access management and Unity Catalog.
• Experience supporting federal government contracts.
• Experience supporting analytics or research data environments.
• Experience writing technical proposal content and developing proofs of concept.
• Familiarity with federal security frameworks such as FISMA, NIST 800-53, or FedRAMP.
• Preferred certifications: SAFe Practitioner, AWS Certified Solutions Architect or Data Engineer, Databricks Certifications, or CDMP.

The salary range provided represents the estimated compensation for new hires in this position, applicable across all locations. Actual offers may vary based on factors such as the candidate's skills, qualifications, experience, and market conditions. Full Tilt Data complements its base salary offering with a competitive package that includes health benefits, discretionary bonuses, and reimbursement for professional development and training.

Full Tilt Data provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.