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. #J-18808-Ljbffr Ancore Inc

Job Tags

Similar Jobs