Database Analyst

Data Engineer

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

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.

Soft Skills:

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.