Position: SQL Engineer/Senior Developer
Location: Spartanburg, SC
Reporting to: Business Development – Group Director
Responsible for: Functional leadership of two staff members
Purpose of role
- Review, analyze and evaluate business systems and user needs document requirements, define scope and objectives and formulate systems to parallel overall business strategies.
- Participate in the delivery of the Data Warehouse set up project and maintain and improve the data analysis post implementation.
Main responsibilities
- Determine operational objectives by studying business functions; gathering information; evaluating output requirements and formats
- Construct workflow charts and diagrams; studying system capabilities; writing specifications
- Working alongside the external Data Architect, actively participating in the details of the delivery (coding) of the Data Warehouse project and any additional enhancements or business driven changes to the system
- Optimise / automate data flows and reporting processes by utilising Python and other technologies
- Continue rolling out PowerBI across the business and utilising it as the main reporting tool for the Group and the induvial business units
- Recommend controls by identifying problems; writing improved procedures
- Define project requirements by identifying project milestones, phases and elements; forming project team; establishing project budget
- Monitor project progress by tracking activity; resolving problems; publishing progress reports; recommending actions and guiding others
- Maintain user confidence and protect operations by keeping information confidential
- Contribute to team effort by accomplishing related results as needed
- Validate resource requirements and develop cost estimate models
- Interpret, evaluate and interrelate research data and develop integrated business analyses and projections for incorporation into strategic decision-making
- Suggest changes to senior management using analytics to support your recommendations. Actively participate in the implementation of approved changes
- Create informative, actionable and repeatable reporting that highlights relevant business trends and opportunities for improvement
- Conduct insightful, ad hoc analyses to investigate ongoing or one-time operational issues
Please note
From time to time your manager may ask you to undertake reasonable tasks not stated within this role profile but commensurate with your position. The Company also reserves the right to review and update this profile to reflect the changing needs of the job. However, any significant changes will be discussed in consultation with you.
Experience and qualifications required
- Hands on approach, a ‘Doer’ who gets things done
- Bachelor's Degree in appropriate field of study or equivalent work experience
- PowerBase/PowerApps/PowerBI expertise is a must
- Microsoft Access and/or SQL experience is a must
- Python / SnapLogic / other technology expertise strongly preferred
- Experience in setting up or maintaining data warehouses and/or mining data
- Ability to impact operations and effect change without being confrontational
- Detail oriented, analytical and inquisitive
- Ability to work independently and with others in Agile system
- Extremely organized with strong time-management skills
Job Type: Full-time
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Vision insurance
Schedule:
COVID-19 considerations:
The complete requirements will be shared by the HR Department to all new hires upon acceptance of an offer of employment as it pertains to Federal regulations regarding OSHA COVID-19. Most interviews are conducted by phone or MS Teams.
Education:
Experience:
- SQL: 5 years (Required)
- Informatica: 5 years (Required)
- Data warehouse: 5 years (Required)
Willingness to travel:
Work Location: Multiple Locations