SR. Data Stage Developer (Contract to Hire)

Futurewave Systems; Columbus (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

Futurewave Systems is seeking a Sr. Data Stage Developer based in Columbus, Georgia. The ideal candidate will design, develop, and maintain ETL processes and data structures critical for the firm's operations. Responsibilities include working with business analysts to determine technical solutions and ensuring data integrity across platforms.

Candidates should have a Bachelor’s Degree in Computer Science and over six years of relevant experience, including strong ETL skills and a solid understanding of data warehousing. This role offers a chance to work with cutting-edge technologies in a dynamic environment.

Qualifications

• 6+ years of experience with ETL solutions and data warehousing.
• Solid understanding of SDLC and software best practices.
• Experience working in a multi-tier environment.

Responsibilities

• Design and develop data structures and ETL processes.
• Create Data Stage jobs for data movement and transformation.
• Ensure the quality and security of data in warehouse systems.

Skills

Data modeling and database design

ETL processes

Data analysis

SDLC understanding

Documentation skills

Leadership and teamwork

Education

Bachelor’s Degree in Computer Science or related field

Tools

IBM Data Stage / Data Quality software

Job description

SR. Data Stage Developer (Contract to Hire)

is a financial services company based in Columbus, Georgia, with approximately $29 billion in assets. They provide commercial and retail banking, investment, and mortgage services to customers.

Job Summary

Designs, develops, maintains and improves data structures, queries, reporting solutions, extract‑transform‑load (ETL) processes and data warehousing strategies for all mission critical projects. Serves as a subject matter expert in data and databases. Mentors junior staff members and works with other developers and production DBAs to ensure scalable, efficient and optimized solutions. Provides best practice guidance to the development team with regard to database design and usage, including code reviews and data validation. Works closely with customers, management, business analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions. Ensures solutions are aligned with business and IT strategies and comply with the organization’s architectural standards. May lead a team of developers on more complex projects.

Job Duties and Responsibilities

• Designs, develops, tests and troubleshoots applicable software packages that implement complex ETL processes in accordance with business requirements and service level agreements.
• Works with the technical business analyst to understand the design/mapping document and provides feedback, as needed, for clarification.
• Creates Data Stage jobs to implement data movement/data rules to populate the EDW and/or data mart.
• Works with testing team and technical business analysts to resolve any incidents.
• Works with application developers, business partners, management and Data Warehouse team. Extends the data model to house additional structures as needed to meet applicable regulatory requirements. Designs data warehouse or data mart fact tables, aggregate tables, and dimensions. Delivers quality data integration projects, standards, best practices and data dictionary.
• Develops ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds. Develops and documents systems, processes and logic required to expose existing data sets in the warehouse to end users for reporting and analytical purposes.
• Monitors ETL applications for performance and improvement opportunities. Ensures quality, consistency and security of company data and data warehouse systems. Troubleshoots and diagnoses complex software problems. Conducts packaging, release and change management.
• Communicates open items and issues to key stakeholders, including management, development teams, and business areas. Reviews requirements, architecture and design components of ongoing and upcoming Tier 1 projects. Conducts and manages code review sessions between developers to review applicable software programs and packages, stored procedures, and views.
• Keeps informed of tools, techniques and components utilized in the industry through research and applies this knowledge to system(s) being developed.
• Each team member is expected to be aware of risk within their functional area. This includes observing all policies, procedures, laws, regulations and risk limits specific to their role. Additionally, they should raise and report known or suspected violations to the appropriate Company authority in a timely fashion.
• Performs other related duties as required.

Minimum Education

Bachelor’s Degree in Computer Science, Information Systems, or related field or equivalent relevant experience.

Minimum Experience

Six years of experience designing, developing, testing, and implementing ETL solutions utilizing applicable software products and experience working with data warehousing and data marts OR an equivalent combination of education and experience.

Required Knowledge, Skills, & Abilities

• Knowledge of data modeling and designing databases.
• Good knowledge of metadata and using/managing metadata.
• Solid understanding of systems development life cycle (SDLC), software best practices and development methodologies.
• Understanding of building data warehouses for analytical and business intelligence solutions.
• Understanding of business solutions that the data warehouse serves.
• Strong technologist with excellent data analysis and ETL skills.
• Strong architecture/design/development skills.
• Strong analytical and diagnostic skills.
• Skill in developing and organizing high‑quality documentation.
• Skill and flexibility managing multiple projects with large volumes of data in a rapidly changing environment.
• Skill troubleshooting issues in a multi‑tier environment.
• Skill working with both business team members and technologists.
• Leadership skills with an emphasis on teamwork.

Preferred Knowledge, Skills, & Abilities

• Complete knowledge of IBM Data Stage / Data Quality software.
• Awareness of interactions of Data Stage with other components of the IBM InfoSphere tool suite.
• Self‑starter – aggressive to get the job done.
• Banking industry experience.
• 8‑10 years of relevant experience.
• 5 years IBM InfoSphere tool sweep.
• 3‑5 years Data Stage / Data Quality software.