The Business System Analyst will build and manage ETL pipelines to ingest data into the data lake as well as push data into analytical platforms for use by the business.
- Evaluate, implement and maintain assigned business systems and applications.
- Assist in evaluating proposals for data collection through an understanding of the functional area's business and applications needs.
- Assist in planning and implementing activities required for the collection and analysis of data related to departmental business needs, including the development of data collection systems.
- Maintain specific departmental data collection systems (eg , databases and spreadsheets) by troubleshooting problems, providing user support and education and promoting integration with other systems.
- Develop and run basic queries and other data collection spreadsheets to support assigned business areas and organize them in a format for ease of review and use.
- Distill business processes to key functions and create and document processes to identify opportunities to automate and/or improve an existing process.
- Assist in conducting complicated and detailed analyses of data relative to the applicable business function.
Education:
- High School diploma equivalency with 2 years of cumulative experience OR Associate's degree/Bachelor's degree OR 4 years of applicable cumulative job specific experience required.
Additional Preferences:
- 1-2 years experience in big data engineering, ETL, Data Modeling and Data Architecture
- 1-2 years experience writing SQL
- 1-2 years experience with AWS Glue, AWS Lambda, and AWS Step Functions
- 1-2 years experience with data lakes and building data pipelines
- 1-2 years experience with Agile Project Management
- Proficiency in Python and javascript a must have
- Strong communication skills between all levels of users
- Work independently by prioritizing and managing time