Senior Data Architect

Senior Data Architect

I2X Technologies is a reputable technology services company to the Federal Government. Whether the focus is on space exploration, national security, cyber security, or cutting-edge engineering applications, I2X is ready to offer you the chance to make a real-world impact in your field and for your country. We provide long-term growth and development. Headquartered in Colorado, I2X is engaged in programs across the country and in more than 20 states. Our programs support multiple Federal agencies, the Department of Defense and often focused on the space initiatives of our government customers.

I2X Technologies is seeking a Senior Data Architect to support ongoing activities for a customer in Washington, DC. This position will be on-site.

The ideal candidate is an experienced hands-on data modeler with working knowledge of database design and administration, data pipeline building, and data wrangling who enjoys improving existing data systems and/or building them from the ground up. The Data Architect/Engineer will support our economists and technical experts and will ensure optimal data delivery architecture is designed and developed. They must have a service mindset, be self-directed, and be comfortable supporting the data needs of multiple teams and systems. The right candidate will be excited by the prospect of optimizing or even redesigning the R&S division's data architecture to support our next generation of data initiatives.

Requirements: The candidate shall also demonstrate the below knowledge and experience:

• Analyze data processes, applications, and source data to understand dependencies, anomalies, and implicit business rules that impact the division's ability to manage data.
• Design, develop, and maintain robust data pipelines that ingest, transform, and deliver data from multiple sources to analytics platforms, ensuring optimal performance and data integrity throughout the process.
• Architect and implement ETL/ELT workflows using modern data engineering tools and frameworks to support large-scale data processing for economic analysis.
• Create data solution designs for economic policy and research projects, including conceptual models, integration models, and sourcing strategies, in alignment with the division's research needs and data strategy.
• Define specifications and implement database structures, including logical and physical data models, backup and recovery procedures, and access security controls. Develop and maintain formal documentation of data structures, data flows, data dictionaries, and technical metadata.
• Collaborate with research and business teams to improve data models and data processes that support analytics and visualization tools, increasing data accessibility and fostering data driven decision making across the organization.
• Implement processes and systems to monitor data quality, ensuring production data is accurate, reliable, and available for end users and dependent business processes.
• Identify, design, and implement internal process improvements, including automation of manual processes, optimization of data delivery, and redesign of infrastructure to improve scalability and performance.
• Participate in the development of future-state data architecture standards, guidelines, and principles.

Qualifications:

• Bachelor's degree in computer science, Information Technology, Engineering or a related technical field and at least 7 years of related experience; advanced degree preferred.
• Advanced working knowledge of SQL and experience working with relational database platforms including PostgreSQL, Microsoft SQL Server, and MySQL.
• Advanced working knowledge of Python, R, and other scripting languages used for data engineering and analytics.
• Experience working with large-scale data systems, including distributed computing, scalable data processing, data storage architecture, and optimization of high-volume data workloads.
• Experience designing, developing, and automating ETL/ELT workflows and data integration pipelines.
• Experience building, optimizing, and maintaining scalable databases, data pipelines and data processing frameworks.
• Experience with workflow orchestration and pipeline automation tools such as Apache Airflow, Prefect, Dagster, or AWS Step Functions.
• Experience migrating workflows and data pipelines between on-premises and cloud environments.
• Experience processing, analyzing, and integrating structured and unstructured data sources.
• Experience developing in Linux environments and using source control platforms such as GitLab and/or GitHub.
• Experience performing root cause analysis on internal and external data and business processes to answer business questions and identify opportunities for improvement.
• Ability to design and communicate enterprise information architecture at conceptual, logical, and physical levels.
• In-depth experience designing and implementing database, data lake, and enterprise data platform solutions.
• Strong hands-on software engineering and implementation experience, including development, testing, and deployment of data applications and services.
• Excellent oral and written communication skills with a strong customer service orientation.
• Exceptional analytical, problem-solving, and troubleshooting skills.
• Additional desirable skills/experience include understanding of time series data and related analytical and forecasting techniques, experience working in a research environment and/or with economic or financial data, experience with NoSQL and graph database technologies, experience developing, training, deploying, and maintaining machine learning models, working experience with cloud technologies such as AWS, Microsoft Azure, and Snowflake, experience implementing data warehouses utilizing Change Data Capture (CDC) methodologies, experience implementing and maintaining CI/CD pipelines and DataOps platforms, working knowledge of additional programming and scripting languages such as Java, Scala, JavaScript, or Perl.

Essential Requirements:

US Citizenship is required.

In compliance with Colorado's Equal Pay for Equal Work Act, the annual base salary range for this position is listed. Please note that the salary information is a general guideline only. I2X Technologies considers factors such as (but not limited to) scope and responsibilities of the position, candidate's work experience, education/training, key skills, internal peer equity, as well as, market and business considerations when extending an offer.

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job with or without reasonable accommodation.

While performing the duties of this job, the employee will regularly sit, walk, stand and climb stairs and steps. May require walking long distance from parking to work station. Occasionally, movement that requires twisting at the neck and/or trunk more than the average person, squatting/ stooping/kneeling, reaching above the head, and forward motion will be required. The employee will continuously be required to repeat the same hand, arm, or finger motion many times. Manual and finger dexterity are essential to this position. Specific vision abilities required by this job include close, distance, depth perception and telling differences among colors. The employee must be able to communicate through speech with clients and public. Hearing requirements include conversation in both quiet and noisy environments. Lifting may require floor to waist, waist to shoulder, or shoulder to overhead movement of up to 20 pounds. This position demands tolerance for various levels of mental stress.

I2X Technologies is an Engineering and Information Technology Company focused on providing Services to the Federal and State Government. I2X offers a competitive compensation program and comprehensive benefits package to our employees.