None specified.
Senior ETL Developer
Location
United States
Posted
1 day ago
Salary
$125K - $160K / year
Seniority
Senior
Job Description
Senior ETL Developer
Golden 1 Talent Acquisition Team
Role Description The Sr. ETL Developer provides technical leadership and hands-on expertise with respect to the analysis, design, development, and support of Golden 1’s Informatica ETL implementation. This is a senior position responsible for assisting the ETL Architect with implementation methodologies including standards, design patterns, and best practices for enterprise data warehouse development. The Sr. ETL Developer will assist in leading other ETL developers, ensuring an efficient, high-performance implementation that fully supports the business’ data needs. - Helps create standards, design patterns, and best practices for ETL development in an enterprise data warehouse environment. - Installs, configures, and administrates Informatica PowerCenter and IDQ. Informatica Web Services Hub experience also desired. - Responsible for workflow and mapping analysis, design, development, testing, and configuration. - Functions as both an expert and lead technical resource on ETL projects throughout the project lifecycle. - Provides support for enterprise data warehouse ETL jobs and processes. - Diagnoses and remedies technical problems to ensure platform uptime and application service levels are met. - Supports, maintains, and monitors the health of the platform and associated processes. - Writes high-quality processes utilizing structured development techniques to support process components and development. - Utilizes an agile-based approach to implementing data services and solutions. - Recommends improvements to ETL processes to enhance data delivery, data quality, and overall processing efficiency. - Partners with quality assurance testing teams to identify errors and confirm business specifications have been achieved. - Able to organize and lead code releases using native Informatica PowerCenter capabilities. - Develops support guides and run books for operational support purposes. - Collects information to analyze and evaluate existing or proposed application designs. - Maintains system and programming guidelines by adhering to the software development lifecycle; develops and maintains artifacts related to standards and architecture. - Assists with the definition and implementation of processes, policies, standards, and procedures to assure compliance with corporate and regulatory policies. - Effective oral and written communication skills required to train, direct, and evaluate staff, diagnose, correct, and resolve system problems. - Maintains a thorough understanding of state and federal laws and regulations related to credit union compliance including bank secrecy and anti-money laundering laws appropriate to the position. Qualifications - Bachelor’s degree in Computer Science, Management Information Systems, or comparable discipline or equivalent work experience. - Minimum of five years’ experience designing, developing, and supporting enterprise data warehouse ETL implementations. - Experience with Cloud implementations is essential. - Highly experienced working with Kimball-based data warehouse implementations. - Strong understanding of all aspects of dimensional modeling as it pertains to ETL design and development. - Must have prior experience designing loads for daily and monthly snapshot facts, accumulating snapshot facts, factless facts, type 1, 2, 3, and other hybrid dimension types as well as 3NF and other modeling techniques. - Strong understanding of enterprise architecture, security, management, and monitoring. - Strong understanding of data management best practices and concepts including data quality, reference data, metadata, and data lineage. - Strong SQL skills expected. - Data Integration experience necessary. - This is a master developer role. Requirements - Availability for emergency and on-call duty 24 hours a day, 7 days a week, as needed. - Occasional travel may be required. - Lift and carry communications equipment and computer hardware weighing up to fifty pounds. - Must possess sufficient manual dexterity to skillfully operate applicable computer hardware, a variety of hand tools, and standard office equipment. - May work additional hours to accomplish tasks. Physical Requirements - Prolonged sitting throughout the workday with occasional mobility required. - Corrected vision in the normal range required to configure, test, and troubleshoot network server hardware and data. - Hearing within normal range. A device to enhance hearing will be provided if needed. Licenses/Certifications - Possession of a valid California Driver’s License is required.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• Get up to speed on payment and billing data APIs • Understand the business model and the data behind it • Brainstorm data and ETL/ELT pipeline architecture • Gather business needs from relevant teams • Develop integrations into the Data Warehouse • Model raw data into clean tables • Automate processing with Python scripts • Build clear dashboards for business teams • Implement data validation tests
Data Scientist / AI Engineer
Logicalis SpainSomos Arquitectos Del Cambio, ayudamos a las organizaciones a tener éxito en un mundo cada vez más digitalizado.
• Diseñar, entrenar y validar modelos de machine learning y deep learning. • Participar en proyectos de clustering, clasificación, regresión y detección de anomalías. • Aplicar técnicas de NLP para extracción de información, resumen automático y análisis semántico. • Integrar modelos en pipelines productivos. • Colaborar en pruebas de concepto (POC), validaciones funcionales y despliegues en cloud (Azure, Google Cloud). • Contribuir a la documentación técnica y al plan de formación para usuarios y equipos de soporte. • Asegurar el cumplimiento de los estándares de IA Responsable y normativa europea de IA.
• Provide architectural oversight for the company’s data platform and related initiatives, ensuring alignment with company standards and best practices • Assist development initiatives with design reviews, offering guidance on architecture and data modeling • Lead design reviews for proposed solutions, including data sourcing, data pipelines, data models, and ontology resources, providing actionable feedback to enhance design scalability • Assist and develop architectural artifacts, perform requirements decomposition, and develop other documentation to support the software development lifecycle (SDLC) • Support the SDLC process by participating in data architecture review sessions, reviewing proposed solutions for compliance with architectural standards • Oversee and provide guidance for data pipelines, ensuring scalability, reusability, and performance • Utilize Palantir Foundry to perform data integration and ontology management to support big data analytics at scale • Collaborate with cross-functional teams to define data governance, metadata, and ontology standards, ensuring consistency and clarity across the data platform and enterprise • Remain current with emerging data technologies and frameworks to recommend improvements to the data platform architecture.
Senior Data Engineer - Data Insights
AppfireAppfire is a computer software company that has been recognized as a “global authority” on Atlassian products and software. As an employer, the company aims
Role Description Data is the fuel behind Appfire's global footprint. We’ve grown fast, and now our focus has shifted toward building the most mature, high-performing data platform in our industry. We are looking for a Senior Data Engineer to take ownership of our core infrastructure, champion engineering excellence, and help shape the future of our data ecosystem. Leveraging your expert Python, SQL, and cloud infrastructure skills, you will develop pragmatic architectures that ensure stability and performance across the organization. As a key member of our central data insights team, you will evolve our custom data lake ("firelake" built on AWS and Snowflake). To accelerate our platform optimization efforts, you will ruthlessly eliminate technical debt, resolve edge cases, and introduce modern, AI-driven development practices. This isn't just about maintaining pipelines; it's about architecting a highly secure, resilient, and scalable foundation that empowers company-wide decision-making. If you love solving complex data puzzles, driving overarching data strategy, and seeing the direct impact of your work across an entire organization, let's talk. Qualifications - 5+ years in a data or software engineering role with a deep understanding of the full data lifecycle, modern data warehousing, and agile software development best practices. - 5+ years of experience autonomously building scalable data products, pipelines, and solutions that support company-wide systems and overarching business goals. - Exceptional personal organization and multitasking skills, with the ability to work with minimal supervision while driving 3-5 concurrent cross-departmental projects. - 5+ years of advanced SQL optimization and complex ETL/ELT pipeline development, with extensive, hands-on experience in Snowflake. - 5+ years of advanced Python programming. - 5+ years of experience designing and maintaining AWS cloud environments. Strong, hands-on proficiency with Terraform and Docker is required. - Deep operational experience with Airflow for orchestration, dbt (3+ years) for transformation, and familiarity with managing Fivetran pipelines. - Proven ability to design pragmatic, cost-effective architectures from scratch that prioritize security, scalability, and high performance without over-engineering. - Incredibly strong troubleshooting skills with a ruthless dedication to reducing technical debt, optimizing CI/CD pipelines, and enforcing strict version control and testing standards. - Solid understanding of modern data governance principles, including automated data classification, PII masking, and row/column-level access controls. - Strong written and verbal skills, with a proven ability to translate and simplify complex technical architectures to both engineering peers and non-technical business stakeholders. - A team-oriented mindset with a passion for coaching and providing constructive feedback to junior team members. Requirements - Own the complete solution development lifecycle, from driving initial requirements to building Proof of Concepts (POCs) and Minimum Viable Products (MVPs), and continuously iterating to improve and scale production solutions. - Work closely with internal and external partners to stand up and optimize robust data delivery solutions. Build, manage, and scale complex data pipelines (ETL and reverse ETL) utilizing expert-level Python and Airflow. - Develop standard integration patterns as well as custom data pipelines that interface with atypical APIs to efficiently extend our data delivery capabilities. - Architect and maintain highly efficient, cost-effective scalable data solutions and cloud infrastructure from scratch. - Be the key driver in the evolution of our custom data lake ("firelake" built on AWS/Snowflake), serving as the ultimate subject matter expert on our tech stack and data infrastructure. - Manage Fivetran and custom pipeline operations, proactively handle schema drift, and implement rigorous data quality checks to ensure we have ingested a true and accurate representation of all source systems. - Spearhead AI adoption in our daily engineering workflows to automate Pull Requests, enforce new "definition of done" standards, and accelerate CI/CD, test coverage, and release management. - Drive the integration of AI capabilities directly into our data solutions by interfacing with LLMs and developing intelligent assistants and agents to solve complex business problems. - Stay on the forefront of the rapidly evolving data landscape and drive proof-of-concepts for new tools to ensure we leverage best-in-class technologies to scale quickly. - Implement advanced PII management by leveraging automated data classification techniques, applying masking policies, and enforcing sophisticated row-level and column-level security practices. - Develop and deploy robust monitoring solutions and governance strategies to ensure accurate, secure data is available on time and to the correct audience. - Autonomously lead 3-5 concurrent cross-departmental data projects, driving everything from requirements gathering and UAT to production deployment. - Partner seamlessly with business, analytics, and engineering teams, translating complex technical architectures into relatable concepts to influence stakeholders and align goals. - Champion best practices, systematically reduce technical debt, write clear documentation, and provide both technical and soft-skill mentorship to junior team members. Benefits - Work in a product-first SaaS B2B environment focused on building and scaling solutions for large enterprise customers. - Deliver meaningful, high-impact work that directly influences product direction and customer success. - Every Appfire team member is eligible for company equity, fostering a true sense of ownership and connection to our growth. - Employees receive 25 days of paid time off per year. After 5 years of employment, employees receive 30 days per year. - Appfire provides comprehensive coverage through Empire Health, including medical, dental, and vision insurance. Additional protection includes life insurance, critical illness coverage, accidental death and dismemberment, and long-term disability insurance. - To promote health and well-being, Appfire offers a yearly sport allowance of CAD 600, which can be used to cover the cost of various fitness or outdoor activities from gym memberships to sports equipment. - Every employee receives 3 fully paid days each year to participate in Appfire Town, our Corporate Social Responsibility (CSR) program supporting local communities.



