Data Engineer

Company: Public Consulting Group
Location: Cheyenne
Posted on: June 17, 2022

Job Description:

OverviewAbout Public Consulting GroupPublic Consulting Group, Inc. (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986 and headquartered in Boston, Massachusetts, PCG has over 2,700 professionals in more than 60 offices worldwide-all committed to delivering solutions that change lives for the better. The firm has four designated practice areas with extensive experience in all 50 states, clients in six Canadian provinces, and a growing practice in Europe. Often combining resources from two or more practice areas, PCG offers clients a multidisciplinary approach to solve their challenges or pursue opportunities. To learn more, visitwww.publicconsultinggroup.com.ResponsibilitiesPCG currently seeks a Data Engineer. This person will work as part of a technical consulting team with other technical personnel to provide technical services to PCG projects for our clients. This effort may require consultation towards development of user interfaces, business rules, database queries and stored procedures, and enterprise data maintenance.The ideal candidate will interact with internal business and project management teams and various external security partners and deliver data management recommendations based on best practices and established standards for an enterprise data warehouse cloud infrastructure project utilizing AWS and AzureCreate and maintain optimal data pipeline architecture,Assemble large, complex data sets that meet functional / non-functional business requirements.Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS 'big data' technologies.Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.Work with data and analytics experts to strive for greater functionality in our data systems TheQualifications Experience:3-7 years working as part of an agile development team, preferably with at least one of those years in a 100% remote capacityBachelor's Degree in computer science or related field preferred orAssociate's degree with relevant work experience.3+ years of writing high quality documentation describing ETL routines, data mapping, and other artifacts needed to design, get approval, and build data integration and data migration routines3+ years developing ETL packages, either with SSIS or similar tools3+ years optimizing data integration and data migration routines to handle large data setsStrong skillset in tools used for data integration and data migration3+ years designing relational databases, writing, and tuning non-trivial SQL queries3+ years maintaining and/or modernizing legacy codeSelf-reliant and independent pragmatic thinker who prefers a hands-off approach from managementBonus points: AWS/RDS implementation or experience with other cloud services Qualifications:Able to quickly analyze data and data schema and existing SQL routines and procedures.Able to manage a high volume work environment.Excellent communication and interpersonal skills as well as a strong team player.Strong SQL Server and SSMS skillsFollow assigned technical project plans and timelines.Ensure that deliverable content meets the objective that is intended.Review, evaluate, recommend and develop objectives, policies and procedures to ensure that the systems provided are of high quality and meet the needs of the business function being serviced#LI-MB1 #LI-Remote EEO StatementPublic Consulting Group is an Equal Opportunity Employer dedicated to celebrating diversity and intentionally creating a culture of inclusion. We believe that we work best when our employees feel empowered and accepted, and that starts by honoring each of our unique life experiences. At PCG, all aspects of employment regarding recruitment, hiring, training, promotion, compensation, benefits, transfers, layoffs, return from layoff, company-sponsored training, education, and social and recreational programs are based on merit, business needs, job requirements, and individual qualifications. We do not discriminate on the basis of race, color, religion or belief, national, social, or ethnic origin, sex, gender identity and/or expression, age, physical, mental, or sensory disability, sexual orientation, marital, civil union, or domestic partnership status, past or present military service, citizenship status, family medical history or genetic information, family or parental status, or any other status protected under federal, state, or local law. PCG will not tolerate discrimination or harassment based on any of these characteristics. PCG believes in health, equality, and prosperity for everyone so we can succeed in changing the ways the public sector, including health, education, technology and human services industries, work.>

Keywords: Public Consulting Group, Cheyenne , Data Engineer, Engineering , Cheyenne, Wyoming