Senior Data Engineer / ETL Developer
Company: CTG
Location: Albany
Posted on: August 7, 2022
|
|
Job Description:
Senior Data Engineer / ETL DeveloperUnited StatesNew
HotInformation TechnologyJul 21, 2022Post Date22201173Requisition
#Apply for JobShare this JobSign Up for Job AlertsCTG is currently
seeking an experiencedSenior Data Engineer / ETL Developer to
support our Data Warehousing team. This is a remote opportunity
supporting clients in the Pacific Time Zone. JOB RESPONSIBILITIES:
* Engage business stakeholders and SMEs to understand their data
and analytics needs. * Capture data and analytics user stories and
requirements, and translate into technical design requirements. *
Generate data models to support data needs. * Design master and
reference data models and solutions to standardize data. * Perform
data profiling to support the proposed data solutions. * Develop
ETL and data automation code to extract source data, transform to
map to the target model and/or cleanse the data, and load into a
data warehouse or analytical model. * Configure the operational and
analytical database(s) to host data, and develop data marts to meet
the business requirements. * Optimize the ETL data pipelines code
and configure data interface tools and APIs as needed. * Engage and
collaborate with IT architects, database administrators and
security engineers to configure the data platform(s) and databases
to safely meet the performance expectations. * Develop end user
analytics solutions using business intelligence tools. * Develop
test cases for data validation and end user solution testing. *
Build data validation reports and scripts to assure data accuracy.
* Work with end users to resolve data errors and functional bugs. *
Document technical data solutions for maintenance and support
purposes. * Deploy data warehousing and analytics solutions from
development, to test, to production environments following IT
lifecycle procedures. * Manage code versioning and archival as
required. * Train end users and senior leaders to use data
solutions to yield business value. * Support end users during
testing and production phases, and resolve data tickets and issues
as they arise. * Coordinate and collaborate with project managers,
SCRUM master, and business to meet expected project outcomes. JOB
REQUIREMENTS:Data Engineering* Ideal candidate should have 10+
years of Data Engineering experience with strong SQL development
background, including hands-on experience in ETL development and
Data Warehousing. * Proficient in operational and analytical data
warehousing modeling using tools such as Oracle SQL data modeler,
ER/Studio, ERWIN or similar. * Experience performing data profiling
and generating profiling reports to make data acquisition, modeling
and clean up decisions. * Significant experience with ETL tools.
Knowledge in Microsoft SSIS and SSAS is preferred. * Applied
experience working with Microsoft SQL and Oracle databases. *
Experience working with data interface APIs and ETL software (e.g.
Informatica, Microsoft SSIS, or similar to extract source data from
on-premise or Cloud hosted systems. * Develop ETL test scripts
based on technical specifications/Data design documents and source
to target mappings.Data Testing* Validating target tables with
record counts, duplicate data, reconcile counts with source and
data type. Validation of a Data Warehouse containing multiple data
sources, and testing distributed systems. * Understanding of REST
based API testing and JSON * Experience in writing complex SQL
scripts for data validation and python scripts for creating test
automation. * Experience in writing test cases in a test driven
development environment, particularly in python. * Demonstrated
experience in test data preparation. * Demonstrated experience with
understanding the business requirements and test cases to generate
large volumes of test data to support the requirements and test
cases. * Passion and ability for solving intractable data problems.
Data reporting and analytics* Demonstrated experience developing
operational reports and dashboards using Microsoft PowerBI, SAP
Business Objects, and other similar tools. * Build and configure
Microsoft SSAS models to support the data reporting requirements. *
Configure data and reporting security to manage user access and
sensitive data. Communication and collaboration* Working knowledge
in finance, sales and manufacturing data. * Technical design and
user requirements documentation. * Excellent analytical and
troubleshooting skills. * Excellent verbal and written
communications skills. * Experience working in a waterfall and
agile/SCRUM delivery methodology environment. Education* Bachelor
or Master Degree in computer science, data science, or related
field. * Professional IT certifications such Microsoft, Oracle, AWS
and/or Data Warehousing preferred. To Apply:To be considered,
please immediately apply to this requisition using the link
provided.Kindly forward to any other interested parties-thank
you!Drug testing and/or other employment-related inquires may be
conducted. CTG's Benefits Plan allows you to select insurance
coverage that best suits your lifestyle, and take part in our
savings programs and educational plans. We offer Flexible Spending
Accounts, a 401(k) Retirement Plan, and an Employee Stock Purchase
plan. Our educational plan comprises access to more than 2,000
web-based technical, professional and business development
courses.CTG is a leading provider of digital transformation
solutions and services that accelerate clients' project momentum
and achievement of their desired IT and business outcomes. Our
vision is to be an indispensable partner to our clients and the
preferred career destination for digital and technology experts.
CTG has operations in North America, South America, Western Europe,
and India. For more information, visit www.ctg.com.Our culture is a
direct result of the people who work at CTG, the values we hold,
and the actions we take. In other words, our people are the
culture. It's a living, breathing thing that is renewed every day
through the ways we engage with each other, our clients, and our
communities. Part of our mission is to cultivate a workplace that
attracts and develops the best people, reflected by our recognition
as a Great Place to Work-certified company across many of our
global operations.CTG will consider for employment all qualified
applicants including those with criminal histories in a manner
consistent with the requirements of all applicable local, state,
and federal laws.CTG is an Equal Opportunity and Affirmative Action
Employer. CTG will assure equal opportunity and consideration to
all applicants and employees in recruitment, selection, placement,
training, benefits, compensation, promotion, transfer, and release
of individuals without regard to race, creed, religion, color,
national origin, sex, sexual orientation, gender identity and
gender expression, age, disability, marital or veteran status,
citizenship status, or any other discriminatory factors as required
by law. Our Affirmative Action program serves to promote
occupational equality and diversity through good faith efforts. CTG
is fully committed to promoting employment opportunities for
members of protected classes.Additional Information * Job Function:
Data Warehousing * Education Level: Bachelor's Degree ( -16 years)
* Work Remote: Yes * Travel: No
Keywords: CTG, Albany , Senior Data Engineer / ETL Developer, IT / Software / Systems , Albany, New York
Click
here to apply!
|