Database Analyst
5 months ago
Position will contribute to the understanding, implementation, and flow of data through manufacturing processes. This position will work alongside developers, customers, and digital architects to bring data to the platform through ETL or SQL development. This role will focus on developing and maintaining the governance frame to ensure the platform is secure, data accurate, high quality and efficient. The position will notify the programmers and end users of gaps of data that would disallow the ability to produce a distinct metric. The position will work alongside the Enterprise Factory Data Lake team to ingest and withdraw information allowing the US Drivetrain Digital team to integrate and work with the data lake data as well as pass information back. The position will also contribute to Power BI and report generation and automation. The position will be considered a subject matter expert in data types that are either categorical or continuous when discussing metric related needs
Typical Day
A typical day will involve process planning, process implementation, debugging and metric generation. This will include meeting with stakeholders and documenting requirements. This position will identify any data gaps as well as inform the team of redundancies or inefficiencies. This is an on-site full-time position- no remote work.
Technical Skills
- Competent to perform all necessary ETL (data extraction, transformation, and loading) related task which could include request data access, setup data connection, develop/improve/test ETL procedures, schedule/monitoring ETL scheduled jobs and respond to issues.
- Work with application/report developers to support project planning, training, guidance on standards, and the efficient creation/maintenance of high-quality data.
- Maintain, execute, and monitor data platform governance procedure.
- Respond to issues in access control, data quality control, database structure standard and resource usages.
- Contribute to standard procedures, standard works, continues improvement of data quality, data security and efficiency, as well as technical requirements
- Develop reports, queries, and other data centric application to support business customers or database governance requirements.
- Skilled in SQL and stored procedures
- Skilled in Java-script, Python or Powershell
- Skilled in Git
- Strong understanding of data governance, data quality, data modeling, and data architecture concepts. Strong database design knowledge and can apply data normalization in table design. Strong skill in query performance turning.
Comfortable asking questions and voicing concerns
Comfortable letting stakeholders know when something needs to be changed to reach results.
Ability to work collaboratively in a complex, rapidly changing, and culturally diverse environment.
Education Requirements:
Bachelor's degree in computer programming or equivalent training required w/ 2-4 years of experience required. Associate's w/ 5-7 years of experience required; Certificates from reputable MOOC/bootcamp, or experience with publicly accessible portfolio examples like GitHub or other git-based repositories
Required Skills : SQL, ETL, Power BI,
Basic Qualification :
Additional Skills :
Background Check :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship :Yes
Interview times set : :No
Type of project :Administration/Support
Master Job Title :DBA: SQL Server
Branch Code :Bloomington
-
Database Analyst/Programmer
16 hours ago
Peoria, Illinois, United States TriOptus LLC Full timeJob Title & ID #Database Analyst/ProgrammerDuration:12 monthsLocation:IL-Peoria-Building LC OfficeSummary:The primary function of a database analyst/programmer is to oversee changes to computer databases, test, and implement the database utilizing knowledge of database management systems. A typical database analyst/programmer is responsible for planning,...
-
Database analyst/Programmer 2
2 weeks ago
Peoria, United States TriOptus LLC Full timeJob Title & ID #: Database analyst/Programmer 2 Duration: 12 months Location: IL-Peoria-Building LC Office Summary: The main function of a database analyst/programmer is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems. A typical database analyst/programmer is responsible for...
-
Database analyst/Programmer 3
1 week ago
Peoria, United States Saxon Global Full time100% Remote [(WILL have to be in office 1-2x a year for meetings)]Position Title: Database Analyst/Programmer 3Typical Day: 8am-5pm with some flex - Some start at 7am and leave at 3-4pm12-Month Contract with likely chance for FTEAvailability to start by July 5th On Call: 2 week rotation, 2 weeks on 2 weeks off, could look like 2-3 calls per week, some weeks...
-
Data Analyst
1 week ago
Peoria, Illinois, United States Saxon Global Full timeJob Title: Technical Data AnalystJob Summary:We are seeking a highly skilled Technical Data Analyst to join our team at Saxon Global. As a Technical Data Analyst, you will play a critical role in analyzing and interpreting complex data to drive business decisions and improve profitability.Key Responsibilities:Analyze cost, price, supplier, and engineering...
-
IT Data Analyst
4 hours ago
Peoria, Illinois, United States Caterpillar Full timeJob Title: IT Analyst III-ApplicationsCaterpillar Inc. is seeking a highly skilled IT Analyst III-Applications to join its team. As a key member of the data analytics group, you will work closely with developers, customers, and digital architects to bring data to the platform through ETL or SQL development.Key Responsibilities:Develop and maintain the...
-
Data Analyst
1 day ago
Peoria, Illinois, United States Saxon Global Full timeJob Title: Technical Data AnalystJob Summary:We are seeking a highly skilled Technical Data Analyst to join our team at Saxon Global. As a Technical Data Analyst, you will play a critical role in analyzing and interpreting complex data to drive business decisions and improve operational efficiency.Key Responsibilities:Analyze cost, price, supplier, and...
-
Snowflake Database Administrator
1 week ago
Peoria, United States Caterpillar Full timeCareer Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable...
-
QA Test Analyst 3
4 weeks ago
Peoria, Illinois, United States Saxon Global Full timeJob Title: QA Test Analyst 3Saxon Global is seeking a highly skilled QA Test Analyst 3 to join our team. As a QA Test Analyst 3, you will play a critical role in ensuring the quality of our software applications.Key Responsibilities:Design and develop test plans, scenarios, and scripts to identify software problems and their causes.Test system modifications...
-
IT Solutions Developer
1 day ago
East Peoria, Illinois, United States CATERPILLAR INC Full timeAbout the RoleCaterpillar Inc. is seeking a highly skilled IT Analyst to join our team. As an IT Analyst, you will play a critical role in shaping the company's technology landscape.Key ResponsibilitiesDevelop agile development and data analytics skills to meet business needs.Analyze customer requirements and design solutions that are implementable and...
-
Snowflake Database Administrator
4 weeks ago
Peoria, United States Caterpillar Full timeCareer Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable...
-
Snowflake Database Administrator
4 weeks ago
Peoria, United States Caterpillar Full timeCareer Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more...
-
Snowflake Database Administrator
3 weeks ago
Peoria, United States Caterpillar Full timeCareer Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more...
-
IT Analyst III-Applications
2 days ago
Peoria, United States Caterpillar Full timeCareer Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable...
-
Senior Ministry Financial Analyst
1 month ago
Peoria, United States OSF HealthCare Full timeOverviewHybrid Position Expected pay for this position is $40.83 - $48.03/hour. Actual pay will be determined by experience, skills and internal equity. POSITION SUMMARY: The Senior Ministry Financial Analyst supports financial planning and analysis, business development, and business performance of the health system. As an integral part of the OSF Ministry...
-
QA Test Analyst 3
3 weeks ago
Peoria, United States Saxon Global Full timeSummary: The main function of a QA test analyst is to develop and execute software test plans in order to identify software problems and their causes. An entry level QA test analyst will typically run scripts given to them; as they progress, the analyst is responsible for the development of scripts. Job Responsibilities: •Design test plans, scenarios,...
-
QA Test Analyst 3
2 months ago
Peoria, United States Saxon Global Full timeSummary: The main function of a QA test analyst is to develop and execute software test plans in order to identify software problems and their causes. An entry level QA test analyst will typically run scripts given to them; as they progress, the analyst is responsible for the development of scripts. Job Responsibilities: • Design test plans, scenarios,...
-
QA Test Analyst 3
2 weeks ago
Peoria, Illinois, United States Saxon Global Full timeJob Summary:The primary function of a QA Test Analyst is to develop and execute software test plans to identify software problems and their causes. This role requires strong analytical and problem-solving skills, as well as the ability to work independently and manage time effectively.Key Responsibilities:Design and develop test plans, scenarios, and scripts...
-
IT Analyst III-Applications Specialist
14 hours ago
Peoria, Illinois, United States Caterpillar Full timeAbout the RoleCaterpillar Inc. is seeking a highly skilled IT Analyst III-Applications to join its team. As a key member of the data analytics group, you will play a crucial role in supporting the centralized data platform by collaborating with developers, customers, and digital architects to bring data to the platform through ETL or SQL development.Key...
-
Senior Programmer Analyst
2 weeks ago
East Liverpool, Ohio, United States Heritage Environmental Services Full timeJob Summary:Heritage Environmental Services is seeking a skilled Sr. Programmer Analyst to join our team. As a key member of our IT department, you will be responsible for designing, developing, and maintaining applications that support our operations at the Heritage Thermal Services plant in East Liverpool, OH.Key Responsibilities:Develop and implement...
-
Business Intelligence Analyst
1 week ago
East Helena, Montana, United States CAI Full timeJob SummaryWe are seeking a highly skilled Business Intelligence Consultant to join our team at CAI. As a Business Intelligence Consultant, you will be responsible for developing and maintaining business intelligence solutions using Tableau and Power BI.Key ResponsibilitiesDevelop new and update existing dashboards using Tableau Desktop and Tableau...