Description This position focuses on developing, implementing, and maintaining architecture solutions across a large enterprise data warehouse to support effective and efficient data management and enterprise-wide business intelligence analytics. Responsibilities: - Implement and optimize data pipeline architectures for sourcing, ingestion, transformation, and extraction processes, ensuring data integrity and compliance with organizational standards. - Develop and maintain scalable database schemas, data models, and data warehouse structures; perform data mapping, schema evolution, and integration between source systems, staging areas, and data marts. - Automate data extraction workflows and create comprehensive technical documentation for ETL/ELT procedures; collaborate with cross-functional teams to translate business requirements into technical specifications. - Establish and enforce data governance standards, including data quality metrics, validation rules, and best practices for data warehouse design and architecture. - Develop, test, and deploy ETL/ELT scripts using SQL, Python, Spark, or other relevant languages; optimize code for performance and scalability. - Tune data warehouse systems for query performance and batch processing efficiency; apply indexing, partitioning, and caching strategies. - Perform advanced data analysis, validation, and profiling using SQL and scripting languages; develop data models, dashboards, and reports in collaboration with stakeholders. - Conduct testing and validation of ETL workflows to ensure data loads meet SLAs and quality standards; document testing protocols and remediation steps. - Troubleshoot production issues, perform root cause analysis, and implement corrective actions; validate data accuracy and consistency across systems. Basic Qualifications: - Minimum of 3 years of experience in data analysis. Additional Qualifications: - Strong analytical and problem-solving skills with attention to detail. - Proficiency in SQL and ability to develop complex queries (e.g., multi-join), tune performance, and troubleshoot. - Experience with Unix/Linux shell scripting for ETL automation. - Familiarity with database tools and platforms (e.g., Teradata, Oracle, Non-Relational). - Excellent verbal and written communication skills; ability to collaborate across all levels. - Ability to prioritize and multi-task in a fast-paced environment. - Knowledge of Java/J2EE, REST APIs, Web Services, and event-driven microservices. - Experience with Kafka streaming, schema registry, OAuth authentication. - Familiarity with Spring Framework, GCP services, Git, CI/CD pipelines, containerization, and data ingestion/data modeling. Preferred Qualifications: - Experience with Databricks concepts and terminology (e.g., workspace, catalog). - Proficiency in Python and Spark. - Background in architecting real-time data ingestion solutions using microservices and Kafka. Working at ICF ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy. We will consider for employment qualified applicants with arrest and conviction records. Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please email Candidateaccommodation@icf.com and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.  Read more about workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. Candidate AI Usage Policy At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.  However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at candidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.   Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. The pay range for this position based on full-time employment is: $74,090.00 - $125,954.00 Nationwide Remote Office (US99)

Working at Atlassian Atlassians can choose where they work - whether in an office, from home, or a combination of the two. That way, Atlassians have more control over supporting their family, personal goals, and other priorities. We can hire people in any country where we have a legal entity. Learn how we work at go.atlassian.com/distributed . Your Future Org Atlassian's Intern program combines hands-on technical training, professional growth opportunities, dedicated mentorship, and strong social connections. This holistic approach empowers students to hit the ground running and sets them up for a successful and impactful career at Atlassian! Applications will be accepted from Australian and New Zealand Citizens and Australian Permanent Residents. Our paid internship program runs for 12 weeks between November-February. Your Future Team Join Atlassian's Analytics & Data Science team for the summer and use your skills to influence millions of teams around the world. You'll report to a manager within the Data Science team where you'll build understanding of data science's value through a structured project, and share recommendations with peers and leadership to drive critical decisions. - Measure the impact of product strategy; design and analyse experiments and launches. - Build data-driven recommendations and present insights to peers and leadership to influence decisions. - Partner across engineering, product, design and analytics to improve customer experiences. Minimum Qualifications - Able to commit to a 12-week full-time (40hrs/week) program from November 2026 - February 2027. - Currently enrolled full-time in a Bachelor's or Master's degree and returning to the program after the completion of the internship, graduating by January 2028. - Experience manipulating data using one of SQL, R, Python (or other languages). Preferred Qualifications - Prior project, internship or publication demonstrating experimental design, causal inference, or strong analytical storytelling. - Experience with experiment platforms, dashboards, or data visualisation. Benefits & Perks Atlassian offers a wide range of perks and benefits designed to support you, your family and to help you engage with your local community. Our offerings include health and wellbeing resources, paid volunteer days, and so much more. To learn more, visit Atlassian Internships: Students and New Grads | Atlassian . About Atlassian At Atlassian, we're motivated by a common goal: to unleash the potential of every team. Our software products help teams all over the planet and our solutions are designed for all types of work. Team collaboration through our tools makes what may be impossible alone, possible together. We believe that the unique contributions of all Atlassians create our success. To ensure that our products and culture continue to incorporate everyone's perspectives and experience, we never discriminate based on race, religion, national origin, gender identity or expression, sexual orientation, age, or marital, veteran, or disability status. All your information will be kept confidential according to EEO guidelines. To provide you the best experience, we can support with accommodations or adjustments at any stage of the recruitment process. Simply inform our Recruitment team during your conversation with them. To learn more about our culture and hiring process, visit go.atlassian.com/crh .

• Develop and maintain ETL/ELT pipelines using Informatica PowerCenter or IDMC, or Hadoop, or Databricks, or Azure Data Factory (ADF). • Design data models (star schema, snowflake, one big table, etc.) for analytics and data products. • Work with big data tools (Spark/Databricks) and Azure cloud services. • Optimize both cost and performance of data processes on Databricks. • Contribute to documentation, standardization, and best practices for the team. • Collaborate with business areas, analysts, and data scientists. • Collaboration and development • Autonomy, organization, and a strong sense of technical ownership. • Good communication with technical and non-technical teams. • Proactivity and a continuous desire to learn.

• Lead the design and evaluate the data architecture to be used to solve a problem. • Build robust, scalable, and highly available data pipelines. • Resolve critical incidents and serve as a technical reference. • Apply standards, best practices, and policies defined by the data governance team. • Implement observability processes (monitoring, alerts, logging). • Mentor Junior, Mid-level and Senior Engineers; perform code reviews. • Contribute to the strategy and roadmap of the data platform. • Collaboration and development • Technical leadership, strategic vision, and clear communication. • Ability to influence decisions and anticipate risks. • Ownership mentality, with a focus on scalability and resilience.