Data Engineer
Madison, IN, USA Req #530 Tuesday, May 7, 2024
Job Role / Summary :
The Data Engineer would leverage their expertise in engineering solutions that work with structured and unstructured datasets to optimize company-wide business problems, Machine Learning Models and bring data-driven solutions into production to make real business impact.
The Data Engineer would build data pipelines that drive analytic solutions. This role requires deep understanding of data architecture, data engineering and a basic understanding of data analytics & data science techniques and workflows.
The ideal candidate is a skilled data and software engineer with experience creating data products supporting analytic solutions for multiple teams, systems & products.
Job Responsibilities :
Essential & Secondary Functions :
Responsibility & Customer-Focused :
- Design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals using Azure Data Factory and SSIS
- Have working experience with the Big Data technology like Azure.
- Advanced working SQL knowledge and experience working with relational databases, DB2 databases, working familiarity with the variety of databases.
- Experience writing complex T-SQL scripts in SQL Server Management Studio (SSMS) to interact with relational databases using DDL, DML, DQL, and TCL commands.
- Advanced working Python or R knowledge.
- Basic understanding of Machine Learning techniques.
- Solve complex data problems to deliver insights that helps the organization’s business to achieve their goals.
- Create data products for analytics team.
- Prepare data for prescriptive and predictive modeling.
- Identify, design, and implement internal process improvements : automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Advice, consult, mentor and coach other data and analytic professionals on data standards and practices.
- Foster a culture of sharing, re-use, design for scale stability and operational efficiency of data and analytical solutions
- Lead the evaluation, implementation and deployment of emerging tools and process for analytic data engineering to improve the organization’s productivity as a team.
- Experience supporting and working with cross-functional teams in dynamic environment.
- Partner with business analysts and solution architects to develop technical architectures for strategic enterprise projects and initiatives.
- Responsible to follow and carry out corporate procedures, policies, guidelines, legal requirements, etc.
Integrity :
Use skills, training, and experience to provide a safe work environment for the production and on-time delivery of quality products.
Safety :
- Responsible to follow all safety procedures and practices.
- Use skills, training, and experience to provide a safe work environment for the production and on-time delivery of quality products
Quality :
Ensures and maintains the quality guidelines, procedures, and standards are consistently followed throughout the manufacturing operation.
Other Functions :
Required to follow any other instructions and to perform any other duties as requested by supervisor.
Competencies :
- Safety Awareness
- Quality Driven
- Respectful
- Honesty
- Customer Driven
- Family Oriented
- Responsible
- Innovative
- Responsible Corporate Citizen
- Team Player
- Positive Attitude
- Detail Oriented
- Effective Communication (written and verbal)
- Results Oriented
- Process Improvement
- Cooperation with Others
Education, Experience, Training, Certifications and Licenses :
Degree or equivalent experience :
Bachelor's degree in computer science or equivalent job experience
Years of experience :
Minimum of 3-5 years
Training in :
As required.
Licenses in :
As required.
Certifications in :
As required.
Other requirements :
Must successfully pass any pre-screening test(s).
Knowledge, Skills, and Abilities :
Knowledge in :
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
- Advanced programming experience with Python or R
- Experience building and optimizing big data’ data pipelines, architectures, and data sets.
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- Strong analytic skills related to working with unstructured datasets.
- Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
- Good project management and organizational skills.
- Experience supporting and working with cross-functional teams.
Skills in :
- Attention to detail
- Complex Problem solving
- Work as a productive member of a team
- Work independently with direction
- Multi-tasking
- Organization
- Excellent written and oral communication
Demonstrated ability to :
- Manages multiple assignments simultaneously and demonstrate strong organizational skills
- Ability to interact with all levels of employees
- Work with user community and other IS personnel to gather requirements.
- Work at a highly motivated level with a sense of urgency and dedication to accomplishing tasks
- Ability to type on computer keyboard for extended periods of time
- Adapt to frequent changes in work environment & prioritization.
- Work with general or minimal supervision
- Leverage existing and potential training
Experience with :
- Big Data Tools
- Relational & NoSQL database
- Data pipeline and workflow management tools.
- Azure cloud services.
- Object oriented languages like Python or R.
- Conflict resolution
- In-depth problem identification, analysis and resolution
- Prioritizing and executing multiple projects
Other :
Experience of working with ERP systems
Experience with Visual Studio
Travel :
Less than 10%
Work Environment :
- Manufacturing and / or professional environment.
- Environment can be hot or cold depending on outside temperatures.
- Requires flexibility to schedule and work hours.
Physical and Mental Requirements :
Physical :
- Climbing Stairs : Ascending or descending stairs to gain access to a building or to move from one floor to another.
- Light Carrying : Physically transporting general office items / materials from one location to another.
- Fingering : Typing for extending periods of time, or otherwise working primarily with fingers rather than with the whole hand or arm.
- Sitting : Particularly for sustained periods of time
- Visual Requirement : Able to see and read PC screens; detect color coding, read fine print, and / or normal type size print.
- Bending and Stooping : Bending body downward and forward by bending spine at the waist.
Mental :
- Ability to understand, remember, and apply oral and / or written instructions or other information
- Ability to organize thoughts and ideas into understandable terminology.
- Ability to compose letters, outlines, memoranda, and basic reports and / or to orally communicate technical information.
- Ability to communicate with individuals utilizing a telephone; requires ability to hear and speak effectively on phone.
- Ability to express or exchange ideas by means of the spoken word, communicating orally with others accurately..
Grote Industries will provide reasonable accommodations, if needed, to qualified individuals with disabilities to assist employees in performing the essential functions of their jobs, unless such an accommodation would create an undue hardship on Grote Industries.
Other details
- Job Family Professional - US
- Pay Type Salary
- Madison, IN, USA
Share this job :