RochesterRecruiter Since 2001
the smart solution for Rochester jobs

Data Analyst / ETL Developer

Company: Technology Consulting Inc.
Location: Rochester
Posted on: November 23, 2020

Job Description:

TCI has an immediate need for a Data Analyst ETL Developer in Rochester, NY. This is not a Corp2Corp opportunity. This is a long-term contract opportunity with the possibility of hire. In addition to competitive, market-rate based pay, TCI provides all our Consultants with Comprehensive MedicalDental Insurance, 401k, Life Insurance and Long-Term Disability benefits. SEEKING LOCAL CANDIDATES ONLY NO REMOTE WORK SUMMARY The Data Analyst ETL Developer will design and build data tables and blended data views within a MS Azure data warehousing environment, leveraging Azure Data Factory to extract data from multiple different database systems into Azure data blobs, and make available to business analysts via Snowflake and MS SQL databases. The Data Analyst ETL Developer role is collaborative in nature, working closely with IT and multiple business teams inside and outside of the organization to support Business Intelligence dashboard solutions that help managers and executives make strategic and tactical business decisions. RESPONSIBILITIES Responsible for planning, installing, configuring and administering databases, including base definition, structure, documentation, long and short-range requirements, operational guidelines, performance monitoring, database tuning, identification and correction of performance bottlenecks, security and integrity controls, and logical-physical database design. Consult with data management teams to get a big-picture idea of the companyrsquos data storage and transformational needs. Read, analyze and digest what a business wants to accomplish with its data, and design the best possible ETL process around those goals. Elicit data requirements from analysts, management, and users. Design and create data warehouse tables and views, and all related extraction, transformation and load of data functions in cloud and on-premise environments. Develop necessary database elements and collaborate with IT or other data providers to obtain the data in an automated fashion. Document tables and transformations in data dictionary. Conduct preliminary testing of solutions before data is extracted to ensure accuracy and completeness of data flows. Test solutions for accuracy and completeness once all the data has been transferred. Tune data processing to optimize performance. Provide maintenance support on all delivered solutions, troubleshooting issues as required. Coordinate with data teams in other organizations. REQUIREMENTS Bachelorrsquos degree in Computer Science, Information Systems, MathematicsStatistics, or related field. Technically capable with coding languages commonly used in ETL development such as SQL, Java, XML. Ability to translate data-related requirements into innovative solutions, drawing on prior education and experience, standard procedures, and basic analysis, including manipulating and interpreting large data sets to provide solutions. Understand data warehouse architecture techniques such as EDW, ODS, DM, ROLAP and MOLAP. Experienced in data modeling. Experience troubleshooting and solving complex technical problems. Experience tracing data to source systems (sometimes many source systems). Understanding of star and snowflake data schemas. Experience completing assignments with minimal supervision and setting objectives to meet the goals of assignments. Ability to establish rapport and collaborate with users, data providers, and management at various levels within an organization. Preferred Qualifications Understanding of MS Azure architecture, including blobs and MS Data Factory strongly preferred. Understanding of data integration with cloud database systems. Understanding data needs of advanced analytics, rules-based and statistical analyses. Understand the basics of the dashboards development lifecycle and industry best practices for reporting. High level competency in Excel (macros, pivot tables, etc.) preferred, including the ability and willingness to reverse-engineer logic. Experience with Tableau or other similar analytics tools. Familiarity with R and Python.

Keywords: Technology Consulting Inc., Rochester , Data Analyst / ETL Developer, Other , Rochester, New York

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Order Picker
Description: Order Picker Buffalo, New York, US 350946163 500 one time bonus PLUS 16.00 - 18.00 per hour paid weekly for Seasonal Package Handlers 18.00 per hour for Pre-load Package Handlers Shift: Preload 3:00 (more...)
Company: UPS
Location: Buffalo
Posted on: 12/6/2020

Local Truck Driver
Description: 2,000 sign on bonus - limited time only J.B. Hunt is hiring local CDL-A dedicated drivers Drive dedicated with J.B. Hunt and enjoy a consistent
Company: JB Hunt
Location: Buffalo
Posted on: 12/6/2020

Retail Co-Manager
Description: Job Description Do you like being challenged to be your best Do you enjoy creative
Company: Hobby Lobby
Location: Buffalo
Posted on: 12/6/2020


Material Handler
Description: Material Handler South Wales, New York, US 350946167 500 one time bonus PLUS 16.00 - 18.00 per hour paid weekly for Seasonal Package Handlers 18.00 per hour for Pre-load Package Handlers Shift: Preload (more...)
Company: UPS
Location: Buffalo
Posted on: 12/6/2020

Material Handler
Description: Material Handler Orchard Park, New York, US 350946166 500 one time bonus PLUS 16.00 - 18.00 per hour paid weekly for Seasonal Package Handlers 18.00 per hour for Pre-load Package Handlers Shift: Preload (more...)
Company: UPS
Location: Buffalo
Posted on: 12/6/2020

Dietary Aide
Description: Dietary Aide- PT Evening Park View, a 5-star rated, 123-bed Care Center, is currently seeking self-motivated, energetic Part-Time Dietary Aides to join our team In this entry-level role, you (more...)
Company: Cassia
Location: Buffalo
Posted on: 12/6/2020

Shop and Deliver - No Experience Required
Description: FULL-SERVICE SHOPPER Why shop and deliver with Instacart Instacart is the North American leader in grocery delivery. We strive to help make grocery delivery effortless, affordable, and accessible (more...)
Company: Instacart Shoppers
Location: Buffalo
Posted on: 12/6/2020

Order Picker
Description: Order Picker South Wales, New York, US 350946162 500 one time bonus PLUS 16.00 - 18.00 per hour paid weekly for Seasonal Package Handlers 18.00 per hour for Pre-load Package Handlers Shift: Preload (more...)
Company: UPS
Location: Buffalo
Posted on: 12/6/2020

Flexible Schedule - Shop and Deliver
Description: FULL-SERVICE SHOPPER Why shop and deliver with Instacart Instacart is the North American leader in grocery delivery. We strive to help make grocery delivery effortless, affordable, and accessible (more...)
Company: Instacart Shoppers
Location: Buffalo
Posted on: 12/6/2020

Material Handler
Description: Material Handler Hamburg, New York, US 350946164 500 one time bonus PLUS 16.00 - 18.00 per hour paid weekly for Seasonal Package Handlers 18.00 per hour for Pre-load Package Handlers Shift: Preload (more...)
Company: UPS
Location: Buffalo
Posted on: 12/6/2020

Log In or Create An Account

Get the latest New York jobs by following @recnetNY on Twitter!

Rochester RSS job feeds