Data Analyst - Sterling, United States - RIT Solutions, Inc.

RIT Solutions, Inc. Sterling, United States

2 weeks ago

Description

Position SummaryThe Data Engineer is responsible for developing and maintaining data pipelines and/or data integrations across the In Warehouse Manufacturing stack.

This includes data ingestion, data transformation, data validation/quality, data pipeline optimization, orchestration; and engaging with DevOps Engineer during CI/CD.

This is a new team at Costco and will be fast paced, highly visible, supporting the business goals by being an industry leader in this space.

This role is focused on data engineering to build and deliver automated data pipelines to and from various data sources, primarily iSeries to and from Microsoft Dynamics 365.

The Data Engineer will partner with product owners, engineering and data platform teams as needed to design, build, test and automate data pipelines that are relied upon across the company as the single source of truth.

Job Duties/Essential FunctionsBuild or extend data models in Dynamics365Integration architecture and performance optimizationIntegration Platform Engineering, Admin. and supportAzure DevOps component to build VMs for Secure Agents (i.e.

Gateways)Data mapping (Source to D365 & D365 to source)Upstream/downstream data flows architecture and design (mainly iSeries, AS400 IBMi as source and destination for data)Develops data pipelines to store data in defined data models and structures to be useable within applications or by other business reporting application or dashboardsIdentifies ways to improve data reliability, efficiency and quality of data management.

Assesses the integrity of data from multiple sources.
Manages database configuration including installing and upgrading software and maintaining relevant documentation.
Develops and operationalizes data pipelines to create enterprise certified data sets that are made available for consumption.

Designs, develops, & implements ETL/ELT processesUses Azure services such as Azure SQL DW (Synapse), ADLS, Azure Event Hub, Cosmos, Databricks, Delta-Lake to improve and speed up delivery of our data products and services.

Implements big data and NoSQL solutions by developing scalable data processing platforms to drive high-value insights to the organization.

Identifies, designs, and implements internal process improvements:
automating manual processes, optimizing data delivery.
Identifies ways to improve data reliability, efficiency and quality of data management.
Communicates technical concepts to non-technical audiences both in written and verbal form.
Regular and reliable workplace attendance at your assigned location.
Ability to operate vehicles, equipment or machinery.
Computer, phone, printer, copier, fax

Non-Essential FunctionsAssists in other areas of the department as necessary.
Assists in other areas of the company as necessary.
Ability to operate vehicles, equipment or machinery.
Same as Essential Functions

Experience, Skills, Education & Licenses/CertificationsRequired:4+ years' experience engineering and operationalizing data pipelines with large and complex datasets.2+ years' hands-on experience with iSeries / IBMi integration3+ years' experience working with Cloud technologies such as ADLS, Azure Databricks, Spark, Azure Synapse, Cosmos DB and other big data technologies.

Extensive experience working with various data sources (DB2, SQL,Oracle, flat files (csv, delimited), APIs, XML, JSON.Middleware solutions, such as IBM ACEAdvanced SQL skills required.

Solid understanding of relational databases and business data; ability to write complex SQL queries against a variety of data sources.

3+ years' experience with Data Modeling and ETLStrong understanding of database storage concepts (data lake, relational databases, NoSQL, or Realm)

Recommended:
Azure Certifications.

Graph QLD365 data entity modelsExperience implementing data integration techniques such as event/message based integration (Azure Event Hub, ), ETL.Experience with Git / Azure DevOps.

Experience delivering data solutions through agile software development methodologies.
Exposure to the retail industry.
Excellent verbal and written communication skills.
Successful internal candidates will have spent one year or more on their current team.

Other ConditionsManagement will review the Job Analysis for this position prior to a job offer.
#J-18808-Ljbffr

Data Analyst

1 week ago

Basic Home Infusion Wayne, United States

**Responsibilities**: · **1. Data Collection and Processing**: · - Extract, clean, and preprocess data from various sources to ensure accuracy and completeness. · - Develop and maintain efficient data pipelines and workflows. · **2. Data Analysis**: · - Perform exploratory data a ...
Financial Data Analyst

1 week ago

National Rural Utilities Cooperative Sterling, United States

Financial Data Analyst · Join a member-driven leader in a fast-paced, challenging and collaborative environment with the shared mission of supporting America's network of rural electric cooperatives. Since its formation in 1969, National Rural Utilities Cooperative Finance Corpo ...
Financial Data Analyst

1 week ago

National Rural Utilities Cooperative Sterling, United States

Financial Data Analyst · Join a member-driven leader in a fast-paced, challenging and collaborative environment with the shared mission of supporting America's network of rural electric cooperatives. Since its formation in 1969, National Rural Utilities Cooperative Finance Corpo ...
Sr. Data Analyst

2 weeks ago

RIT Solutions, Inc. Sterling, United States

Position: Sr. Data Analyst · Duration: Contract to Hire · location: Issaquah, WA & Dallas, TX | Needed local Candidates Only · Client: Costco · End Client Job ID: Costco Req# 8667 · Needed Active LinkedIn. · Important: · Build or extend data models in Dynamics365 · Integr ...
Data Analyst

2 weeks ago

Booz Allen Hamilton Warren, United States

Job Number: R0196574 · Data Analyst The Opportunity: · As a data analyst, you love diving into data and turning it into meaningful insights. With the abundance of structured and unstructured data, you understand the importance of transforming complex data sets into useful inform ...
Data Analyst

1 week ago

Booz Allen Hamilton Warren, United States

Job Number: R0196574 · Data Analyst The Opportunity: · As a data analyst, you love diving into data and turning it into meaningful insights. With the abundance of structured and unstructured data, you understand the importance of transforming complex data sets into useful inform ...
Data Analyst

2 weeks ago

Kyyba Troy, United States

QUALIFICATIONS · Education - Required: Bachelor's Degree in Business, Engineering, Statistics, Computer Science, Mathematics, · Supply Chain or equivalent combination of education and experience · Education - Preferred: Master's Degree or equivalent combination of education an ...
Data Analyst

2 weeks ago

NR Consulting Troy, United States

Summary: · Ability to analyze existing tools and databases. Demonstrated experience in handling large data sets. Strong numeric and problem-solving capabilities. Ability to multi-task projects in an effective and productive manner. Able to prioritize work by dividing time, atten ...
Business Data Analyst

2 days ago

Healthmark Industries Fraser, United States

Healthmark Industries Company was founded in 1969 and employs over 300 people and is a growing company. We strive to provide customers with quality products and support services in a timely and effective manner. · This position will be hybrid, 2 days WFH and 3 in office. · WHAT Y ...
Business Analyst- Data

2 weeks ago

Blue Chip Talent Troy, United States

The DW Business Analyst collects, documents, and maintains the authoritative list of requirements for all development efforts. The technical business analyst is accountable for the design of Enterprise Information Management data integration processes, as well as coordination acr ...
IT Data Warehousing Analyst

1 week ago

Strategic Staffing Solutions Troy, United States

STRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING · Title: IT Data Warehousing Analyst · Duration: 12+ Months · Location: Troy, MI (Remote in Michigan) · Job/Role Description · • This individual will serve as a critical resource in the day-to-day development and maintenance of the ...
Business Data Analyst

1 week ago

Perfict Global, Inc. Troy, United States

About Us: · Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies avail ...
Business/Data Analyst

2 weeks ago

Magna Services Troy, United States

Business/Data Analyst · Job Number: 65740 · Group: Magna Corporate · Division: Magna IT USA - Troy · Job Type: Permanent/Regular · Location: · Troy, MICHIGAN, US, 48083 · Work Style: · Group Description · At Magna, we create technology that disrupts the industry and solves big pr ...
IT Data Warehousing Analyst

3 days ago

HCTec Troy, United States

Position: Data Warehousing Analyst · Length: 6 months with possible conversion at the end · Location: Troy, MI · Onsite/Remote: Remote, prefer local candidate but open to out of the area candidates · Covid Vaccination: Optional · Job Scope/Summary: · Bachelor's Degree, Minimum of ...
IT Data Warehousing Analyst

6 days ago

Strategic Staffing Solutions Troy, United States

STRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING · Title: IT Data Warehousing Analyst · Duration: 12+ Months · Location: Troy, MI (Remote in Michigan) · Job/Role Description This individual will serve as a critical resource in the day-to-day development and maintenance of the ...
Business/Data Analyst

1 week ago

Magna International Troy, United States

Group DescriptionAt Magna, we create technology that disrupts the industry and solves big problems for consumers, our customers, and the world around us. We're the only mobility technology company and supplier with complete expertise across the entire vehicle.We are committed to ...
Healthcare Data Quality Analyst/SAS Programmer

2 days ago

RxAnte Sterling, United States

Job Description · Job DescriptionSalary: · Healthcare Data Quality Analyst/SAS Programmer · Company Overview · Over the next ten years, there will be at least 4.6 million hospitalizations from the misuse of prescription drugs in people 65 or older, resulting in $528 billion in a ...
IT Data Warehousing Analyst

6 days ago

Integrated Resources Troy, United States

Duties: · PRINCIPLE DUTIES AND RESPONSIBILITIES: · Collects, analyzes and summarizes data to support business decisions. · Identifies opportunities for reuse of data across the enterprise. Validates data sources. · Keeps abreast of new Tools & Technology and functionalities acro ...
IT Data Warehousing Analyst

2 days ago

A-Line Staffing Solutions Troy, United States

Job Description · Job DescriptionTitle: IT Data Warehousing Analyst · Location: Troy, MI (Role is currently Remote but may require Onsite availability in the future) · Note: This position is a contract on W2, and is NOT open to C2C · The IT Data Warehousing Analyst will be respon ...
IT Data Warehousing Analyst

1 week ago

InfiCare Technologies Troy, United States

Job Description · Job DescriptionJob Title - IT Data Warehousing Analyst (Remote) · Location - Troy, MI 48083Hourly Pay Rate - $46/hr.Contract to hire position · Shift - Mon-Fri 8 hour/dayNOTE: Remote for now, will eventually work from the HAP office in Troy Will be using Datasta ...