• Build and maintain dashboards and reports in Looker, Power BI, and Tableau — depending on client setup. • Write, optimize, and troubleshoot SQL queries for reporting, analysis, and investigations. • Manage and enhance data transformations with dbt where necessary. • Support clients directly — understand their requirements, translate them into data solutions, and deliver clear insights. • Conduct QA/UAT to ensure data accuracy, consistency, and trustworthiness. • Use Git for version control and collaboration. • Proactively identify opportunities, trends, or risks in marketing data and communicate findings clearly. • Leverage AI tools to be 10x more productive than the average analyst.

Role Description ETL Datawarehouse Developer Location: Remote Project Length: 1 year Status: US Citizen Experience: 5+ years Pay: $65-75/hr Bill: $120 Agency: NOAA Program: NMITS BPA /NOS Data Team Due Date: 6/8 Max sub: 3 2 references with each sub Qualifications - Must have experience in Data Warehousing and ETL/ELT processes - Must be proficient with big data ecosystems and frameworks designed for distributed processing of large datasets in distributed cloud-native frameworks - Must have experience with Data Modeling and Database Design - Must have experience designing frameworks that enforce data policies, standards, and procedures to maintain data integrity and fitness for use - Must have experience and be proficient in managing large, modern, complex data projects, prioritizing tasks, guiding and mentoring teammates, and executing on time and within budget while fostering a culture of excellence and setting technical standards - Must have experience being a central communication hub, acting as a bridge between highly technical teams and non-technical stakeholders - Must be able to articulate complex technical designs, and their implications in clear, concise language Requirements - Experience in Data Warehousing and ETL/ELT processes - Proficiency with big data ecosystems and frameworks - Experience with Data Modeling and Database Design - Experience designing frameworks for data policies and standards - Proficiency in managing large data projects - Ability to communicate between technical and non-technical teams

Role Description We are seeking a mid-level SQL & ETL Developer to support offshore data operations and ensure the reliability of critical data pipelines. This role will focus on monitoring, maintaining, and enhancing ETL processes while collaborating closely with U.S.-based teams. - Monitor and support daily ETL processes to ensure successful and timely execution - Troubleshoot and resolve issues related to ETL workflows, data pipelines, and job failures - Work with SSIS packages and assist in transitioning ETL logic into SQL stored procedures - Develop, maintain, and optimize SQL queries, stored procedures, and data transformations - Collaborate with onshore teams to support data availability aligned with business timelines - Assist in evolving ETL processes toward Python-based solutions (training/upskilling supported) - Support data transformations within the SQL layer for downstream reporting tools - Contribute to data modeling efforts, particularly for reporting and analytics use cases - Follow development best practices and work independently within established standards - Participate in Agile ceremonies including standups, sprint planning, and retrospectives Qualifications - 3-5 years of experience in SQL development and ETL support - Strong SQL skills, including query writing, performance tuning, and stored procedures - Experience with ETL tools, preferably SSIS - Ability to monitor and troubleshoot batch data processes and pipelines - Understanding of data transformation and data modeling concepts - Ability to work independently in a support-oriented environment Preferred Qualifications - Exposure to Python for data processing (or willingness to learn) - Experience with Tableau, including understanding of data logic and reporting layers - Familiarity with Power BI and data modeling concepts - Experience transitioning ETL logic from tools (e.g., SSIS) into SQL or code-based solutions - Prior experience working in an offshore/onshore support model Work Environment & Schedule - Offshore support role with close collaboration with U.S. teams - Must be available to support ETL processes aligned with U.S. Eastern Time (ET) - Typical collaboration hours begin around: 11:00 AM PST / 2:00 PM EST - Participation in Agile ceremonies (standups, sprint planning, retrospectives) held twice weekly

• Design, build, and evolve scalable dbt data models that accurately represent company KPIs and business metrics. • Develop and maintain intuitive Looker dashboards that enable stakeholders to make informed, data-driven decisions. • Partner with Finance, Product, Go-to-Market, and other cross-functional teams to understand business requirements and translate them into scalable analytics solutions. • Collaborate with Data Engineering to ensure reliable, high-quality data is available for reporting and analysis. • Partner with analytics engineers and analysts to establish dbt and Looker best practices, perform quality assurance on data models and dashboards, and support analytics needs across the organization. • Analyze complex datasets to uncover actionable insights that improve business performance, forecasting, and operational decision-making. • Help scope, prioritize, and execute analytics initiatives that deliver measurable value across the company.