ETL Developer

Ancore Inc; Woodlawn (MD); Remote; USD 80,000 - 120,000; Full time

Job summary

Join a forward-thinking company where members are empowered to contribute to a world-class business. This role focuses on supporting a large government agency's research and statistics efforts through the design and development of robust ETL processes. You will leverage your expertise in SQL Server and Greenplum to handle large data volumes, ensuring efficient data migration and warehouse design. This innovative firm values flexibility and teamwork, providing an environment where your analytical skills and attention to detail can shine. If you're ready to make an impact and grow professionally, this opportunity is perfect for you.

Qualifications

• Extensive experience with SQL Server and Greenplum for ETL solutions.
• Strong analytical and communication skills required.
• Experience in data migration and warehousing.

Responsibilities

• Design and develop ETL processes for MI/BI efforts.
• Write complex SQL queries and maintain data processing performance.
• Support project documentation and communicate effectively.

Skills

SQL

ETL Development

Data Warehousing

Analytical Skills

Communication Skills

Troubleshooting Skills

Flexibility and Adaptability

Education

Bachelor's Degree in Computer Science or related field

Tools

Microsoft SQL Server

Greenplum

SQL Server Integration Services (SSIS)

SQL Server Analysis Services (SSAS)

TFS

GIT

PowerShell

FTP

Job description

At ANCORE we strive to create an environment where our people come first. We call our employees members to reinforce that all who join our team are considered company owners and are empowered to share in the rewards and challenges that come from building a world-class business. As one of the largest independent information technology and business process services firms in the world, we realize our continued success depends on our ability to attract and retain top-quality professionals like you.
Become part of a team to help a large government agency support research and statistics efforts that help agency officials make recommendations on reforms.

Work is being conducted remotely during COVID safety measures with an eventual return to onsite work once pandemic conditions have passed. This position is located at the client site in Woodlawn, MD.

Responsibilities

• Design and develop Extract, Transform, & Load (ETL) processes to support MI/BI efforts.
• Expertise in writing complex SQL queries in multiple environments such as Microsoft SQL Server, Greenplum, and Oracle.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Experience in loading data from different sources, building ETL pipelines, and implementing Enterprise Data Warehouses in SQL Server and Greenplum.
• Design and develop optimal code to maintain exceptional performance in processing large volumes of data.
• Good understanding of data distribution and table partitioning in SQL Server and Greenplum.
• Develop and implement an efficient migration process to move ETL objects from development to test and production environments.
• Understand database design, programming concepts, data modeling, and framework management.
• Exposure to SQL Server Database Administration (DBA) role.
• Read, debug, modify, and create complex SQL code associated with a data warehouse.
• Translate business requirements into technical specifications.
• Support the project team throughout the design, development, and testing process.
• Participate in all design reviews and requirement sessions as required.
• Support project documentation as required.
• Communicate ideas to both technical and non-technical people at all levels of the organization.
• Work with Business Analysts, Data Architects, Enterprise Architects, and ETL Architects to ensure business requirements are being met with the solution being developed.
• Mentor other team members in developing, documenting, and modifying ETL components.
• Work with versioning tools such as TFS and GIT.
• Understand business and application requirements, develop and maintain software to support those requirements.
• Ability to work independently and multi-task effectively.

Requirements:

• Extensive experience with Microsoft SQL Server and Greenplum.
• Hands-on experience designing and developing ETL solutions involving large volumes of data for SQL Server and Greenplum.
• Experience with large scale, complex data migration efforts.
• Hands-on experience designing data warehouses including Dimensions and Fact Tables.
• Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized databases; expertise with SQL Server Integration Services and SQL Server Analysis Services.
• Expertise with gpfdist, PuTTY, File Transfer Protocols (FTP), and PowerShell scripting.
• Knowledge of SQL Server DBA activities.
• Excellent oral and written communication skills are required.
• Excellent analytical skills required.
• Flexibility and adaptability are required, especially when working in a large team.
• Strong attention to detail and troubleshooting skills.
• Strong analytical and organizational skills, with excellent written and verbal communication skills.
• Ability to work well under pressure and demonstrate commitment to quality and client satisfaction.
• Ability to prioritize, multitask, meet deadlines, and coordinate schedules with others.