Data Engineer at Tundra Technical Solutions Data Engineer at Tundra Technical Solutions in Alexandria, Virginia Posted in 1 day ago.

Type:

full-time Please note that this posting is for a contract assignment and is not a full-time employment opportunity with Amazon. Candidates selected for roles will be employed as contract workers through Amazon's approved 3rd party Direct Source provider for the duration of the specified project and will not be an employee of Amazon. We are seeking a technically strong Data & Analytics Engineer with deep expertise in SQL, data integration, data warehousing, and reporting. In this role, you will conduct root cause analysis on data and pipeline issues, implement fixes, build enhancements to existing systems, and convert business requirements into scalable data solutions. You will leverage hands-on experience with Redshift, Airflow, ETL patterns, and BI tools to drive continuous improvement across the analytics ecosystem. This is a technically focused, hands-on role for a data professional who excels at diagnosing issues, fixing them, and building better solutions. You will spend your time conducting RCA on data and reporting problems, implementing fixes, building enhancements that improve the analytics ecosystem, and converting business needs into working data solutions. You are equally comfortable troubleshooting a broken Airflow DAG as you are building a new QuickSight dashboard from a stakeholder's requirements.

Key Responsibilities:

Conduct Root Cause Analysis (RCA) on data quality issues, pipeline failures, reporting discrepancies, and business anomalies

• and implement fixes to resolve them Build enhancements to existing data pipelines, reports, metrics, and analytics solutions to improve performance, accuracy, and coverage Convert business requirements into technical data solutions
• translating stakeholder needs into SQL logic, pipeline changes, report designs, and data model updates Work with business stakeholders to define metrics and KPIs, and drive the build of measurement frameworks that track business outcomes and operational health Create dashboards, reports, analyses, and datasets
• preferably in Amazon QuickSight
• to deliver actionable insights to stakeholders at all levels Write advanced SQL in Amazon Redshift for complex data extraction, transformation, analysis, and performance optimization across large-scale datasets Leverage deep experience with ETL/ELT concepts and data integration patterns to drive solutioning and partner with tech teams on pipeline fixes and enhancements Apply strong knowledge of data warehouse architecture and data mart design (star schema, snowflake schema, dimensional modeling) to quickly understand organizational data structures and deliver quality analysis Read, interpret, and troubleshoot Apache Airflow DAGs to understand data pipeline orchestration, identify root causes, and drive fixes with engineering teams Develop Python-based automation scripts and data processing workflows to streamline reporting and analytics Utilize AWS cloud infrastructure (Redshift, S3, Glue, Lambda, Athena, EMR) to support and enhance data solutions Create and manage automation workflows using Smartsheets for operational reporting and tracking Partner with software development and data engineering teams to drive requirements, evaluate technical approaches, and implement the right solution Utilize AI/ML tools and generative AI to enhance data processing and automate repetitive tasks

Basic Qualifications:

5+ years of experience in data analytics, data engineering, or business intelligence Expert-level SQL proficiency

• complex joins, window functions, CTEs, subqueries, query optimization, and performance tuning in Amazon Redshift or similar MPP databases Demonstrated experience conducting RCA, implementing fixes, and building enhancements on data pipelines, reports, and analytics systems Proven ability to convert business requirements into technical data solutions
• pipeline logic, SQL transformations, report builds, and data model changes Deep experience creating dashboards, reports, analyses, and datasets using BI tools
• Amazon QuickSight strongly preferred; Tableau, Power BI, or similar also acceptable Proven ability to work with business stakeholders to define metrics and KPIs, and drive the build of reporting solutions Strong understanding of data integration and ETL/ELT concepts
• extraction patterns, transformation logic, load strategies, incremental vs. full refresh, CDC, and pipeline architecture Deep knowledge of data warehouse and data mart design
• star schema, snowflake schema, fact/dimension tables, slowly changing dimensions, and aggregation layers Hands-on experience with Apache Airflow
• ability to read DAG code, understand task dependencies, troubleshoot failures, and drive fixes with engineering teams Strong Python programming skills (pandas, boto3, SQL libraries, automation scripting) Working knowledge of AWS cloud services (Redshift, S3, Glue, Athena, Lambda) Track record of collaborating with engineering teams to drive data requirements and solution design

Preferred Qualifications:

Experience building and managing QuickSight datasets, calculated fields, parameters, and SPICE-optimized data models Experience with data quality frameworks, data validation, and data governance Experience with Smartsheets for automation and reporting workflows Hands-on experience with AI/ML tools (e.g., Amazon Bedrock, Amazon Q, Copilot, or similar) Familiarity with Git version control and CI/CD for data pipelines Experience with Agile/Scrum methodologies Bachelor's degree in Computer Science, Data Science, Engineering, or related field This posting is for a contract assignment with Tundra Technical Solutions to provide services to Amazon. The pay range that Tundra in good faith reasonably expects to pay for this position is $70.35/hour

• $79.

73/hour. Tundra's benefits offering includes optional medical, dental, vision, retirement benefits, and a New Child Benefit. Pursuant to the California Fair Chance Act, Los Angeles County Fair Chance Ordinance for Employers, Los Angeles Fair Chance Initiative for Hiring Ordinance, and San Francisco Fair Chance Ordinance, qualified applicants will be considered for assignment with arrest and conviction records. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness, meet client expectations, standards, and accompanying requirements, and safeguard business operations and company reputation. Tundra Technical Solutions is among North America's leading providers of Staffing and Consulting Services. Our success and our clients' success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Unincorporated LA County workers:

we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.