Data Engineer & Analyst

Role: Data Engineer & Analyst (SSIS, Posit and R, are MUST)
Duration: 3 Months with a potential for extension/conversion
Location: 100% Remote

Required Work Experience
* Years of Experience
o 3+ years of related work experience
* Experience Details
o Or 1.5 years' experience in an Associate Data Engineer role or experience in Data Analytics

Required Education
* Education Level
o Related Bachelor's degree or additional related equivalent work experience

Additional Info:
* Posit / R
* SSIS
* Transition existing SSIS ETL Pipelines from SSIS to Posit and R

Job Summary:

• The Data Engineer & Analyst works across IT and business functions to create and maintain custom reports and/or data files from multiple access databases and tables well helping drive business decision with business owners through development business comprehensive analyses.
• This role oversees the creation and daily running of mission critical departmental reporting for departmental metric results as well as design and develop Toad and SQL Server stored procedures, functions, and views. This role will provide presentations, documenting analyses, ensure understanding of the analysis with key stakeholder, and support on root causes of trends, issues, and performance gaps based on analyses as well as making and implementing recommendations to drive improvements.

Essential Functions:

• Design and develop ETL using Toad and SQL Server stored procedures or other tools , functions, and views. Create and maintain custom reports and/or data files from multiple access databases.
• Provide oversight for the creation and daily running of mission critical departmental reporting for departmental metric results. Translate business needs to data elements in Access Databases and other data marts to source, extract, and match and modify data to enable reporting efforts.
• Create and maintain custom dashboards and/or data sources in Tableau and other reporting tools; Extract and aggregate data as needed for reporting.
• Develop reports and presentations documenting analyses and ensure that key stakeholders understand the business implications for those analyses.
• Identify, investigate, and document possible root causes of trends, issues, and performance gaps based on analyses and campaign results to determine improvements and recommendations. Perform exploratory data analysis, data cleansing, and data visualization using data mining tools.

Position is offered by a no fee agency.