SI
Remote Associate Data Engineer/Analyst
SGA Inc.
🇺🇸 United States
Remote
1 week ago
$39.29 – $44.29 / hour
- SSIS
- ETL
- Tableau
- Data Visualization
- AI
1 week ago
Top Experience Needed:
• Posit/R
• SSIS
• Transition existing SSIS ETL Pipelines from SSIS to Posit and R
Responsibilities :
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.
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.
- 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.
- Transition existing SSIS ETL Pipelines from SSIS to Posit and R
- Related Bachelor's degree or additional related equivalent work experience
- 3+ years related work experience
- Or 1.5 years' experience in an Associate Data Engineer role or experience in Data Analytics
- Posit / R
- SSIS
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.
Remote Associate Data Engineer/Analyst · SGA Inc.