The ETL Developer will design, develop, and support ETL processes, troubleshoot data issues, validate conversions, and collaborate with stakeholders for project success.
Emergent Method is seeking a qualified ETL Developer to support development and testing activities related to a conversion project for a state government agency. This is a remote, full-time position that will support ongoing project operations. Remote candidates will be considered and are encouraged to apply.
The ideal candidate is experienced, self-motivated, and adept in handling a wide range of data conversion tasks. This individual must be flexible, able to work in a fast-paced environment, and willing to embrace the challenges of supporting the continued development and success of a growing workforce.
Key responsibilities include but are not limited to the following:
Background
Emergent Method is a nationally recognized management consulting firm focused on developing and implementing plans, programs, and initiatives that result in transformative impact. We are focused on strengthening the skills, capacity, and resources of our clients to support them in creating unique and valuable experiences for their stakeholders.
With an uncommonly high degree of ownership in the work we do, our team thrives on solving complex challenges, delivering solutions built to last, and driving transformational growth.
We work from the inside out — fully engaged with our client teams and invested in their success. Their most pressing challenges and opportunities become our own. Our flexible, adaptable approach allows us to work seamlessly as trusted advisers, embedded team members, or both, to support client needs, using every engagement as an opportunity to deliver powerful results, together.
Our expertise travels well to all markets and benefits all sectors, allowing us to work wherever there’s a good client fit. Our consultants have significant experience working across a wide range of industries and in the private, public, and nonprofit sectors. We successfully work within the bounds of both large-scale projects that may span years as well as short-term, time-sensitive efforts.
Our integrated, interdisciplinary team of consultants brings an expansive range of skillsets and experience to power a broad scope of services and solutions. Whether you are looking to develop or implement a new strategy, brand, marketing or communication campaign, IT system, program, or a unique and innovative project, we stand ready to be your partner.
For more information, visit emergentmethod.com.
Emergent Method and associated entities are equal opportunity employers. We do not discriminate against employees or applicants for employment on any legally recognized basis or any protected class under federal, state, or local law.
The ideal candidate is experienced, self-motivated, and adept in handling a wide range of data conversion tasks. This individual must be flexible, able to work in a fast-paced environment, and willing to embrace the challenges of supporting the continued development and success of a growing workforce.
Key responsibilities include but are not limited to the following:
- Develop program modules using SSIS ETL tool (SQL Server Integration Services – ETL tool used for SQL Server Databases) based on defined requirements
- Create and execute SQL queries via SQL database
- Analyze/troubleshoot data integrity issues and data discrepancies
- Validate/test conversion program modules to ensure accuracy
- Manage and execute large number of SSIS modules via SSA (SQL Server Agent)
- Communicate daily status updates to key stakeholders and project team
- Provide technology design and develop and support risk and regulatory platform capabilities, functions, and processes
- Collaborate with source systems’ technical representatives to troubleshoot data issues and to process source systems’ data extracts
- Understand business requirements with respect to data needs
- Analyze source data and perform data gap analysis, source-to-target mappings, and data integration design
- Implement and maintain database schemes to support the transformation of the source systems’ data and loading into the target systems’ databases
- Troubleshoot program modules performance issues and performance tune program modules and database tables
- A bachelor’s degree in computer science, ISDS, or related field
- At least five years of experience utilizing ETL software, such as Informatica and/or SSIS
- At least five years of SDLC (System Development Life Cycle) experience
- At least two years of experience in converting data from a source database to target database, including the loading, transformation, and cleansing of the legacy source system databases
- At least five years of experience working on a SQL server
- At least five years of experience working on relationship databases
- At least five years of experience creating and executing SQL queries and Store Procedures
- At least five years of performing unit testing, integration testing and system testing ETL modules
- At least five years of reporting individual status
- At least one year of experience in developing and testing SSIS programs
- Experience with using JIRA is highly preferred
- Excellent verbal, written, and interpersonal communication skills - ability to articulate complex concepts in a clear manner
- Strong analytical, problem-solving, and interpersonal skills
- High attention to detail and accuracy – strong quality of work and organizational skills
- Ability to prioritize work, meet deadlines, achieve goals, and work under pressure in a dynamic and complex environment
- Experience with applying new technologies to business needs in a technologically innovative, change-driven organization
- Advanced Microsoft Office (Word, Excel, Outlook, and PowerPoint) skills
Background
Emergent Method is a nationally recognized management consulting firm focused on developing and implementing plans, programs, and initiatives that result in transformative impact. We are focused on strengthening the skills, capacity, and resources of our clients to support them in creating unique and valuable experiences for their stakeholders.
With an uncommonly high degree of ownership in the work we do, our team thrives on solving complex challenges, delivering solutions built to last, and driving transformational growth.
We work from the inside out — fully engaged with our client teams and invested in their success. Their most pressing challenges and opportunities become our own. Our flexible, adaptable approach allows us to work seamlessly as trusted advisers, embedded team members, or both, to support client needs, using every engagement as an opportunity to deliver powerful results, together.
Our expertise travels well to all markets and benefits all sectors, allowing us to work wherever there’s a good client fit. Our consultants have significant experience working across a wide range of industries and in the private, public, and nonprofit sectors. We successfully work within the bounds of both large-scale projects that may span years as well as short-term, time-sensitive efforts.
Our integrated, interdisciplinary team of consultants brings an expansive range of skillsets and experience to power a broad scope of services and solutions. Whether you are looking to develop or implement a new strategy, brand, marketing or communication campaign, IT system, program, or a unique and innovative project, we stand ready to be your partner.
For more information, visit emergentmethod.com.
Emergent Method and associated entities are equal opportunity employers. We do not discriminate against employees or applicants for employment on any legally recognized basis or any protected class under federal, state, or local law.
Top Skills
Informatica
JIRA
MS Office
SQL
SQL Server
Ssis
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Manager - Observability, you will lead a team in building metrics and tracing platforms, participate in architecture development, and foster team collaboration.
Top Skills:
AWSBashGCPGoOtelPrometheusPythonSentryTempoThanos
Automotive • Cloud • Greentech • Information Technology • Other • Software • Cybersecurity
As an Account Executive II, you will drive sales of Hybrid Cloud and Professional Services, manage customer accounts, and develop new business.
Top Skills:
AWSAzureGCPSalesforce
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Cloud Software Engineer at CrowdStrike, you will develop scalable cloud solutions, innovate with Large Language Models, and maintain data pipelines while ensuring high coding quality and collaborating with teams.
Top Skills:
AWSCassandraDockerEc2ElasticsearchGitGoIamKafkaKubernetesPythonRedisS3
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
