What are the responsibilities and job description for the Data Warehouse Analyst position at Mazi Workforce Solutions?
Duties/essential functions may include, but not be limited to, the following:
- Responsible for designing, building, and supporting the components of the Enterprise Data Lake, Date Warehouse, and Data Marts to include ETL processes, databases, reports, and reporting environments.
- Develop and automate ETL processes to include error and reconciliation handling using Python, SQL, and DBT.
- Create processes for adding, maintaining and/or updating data from disparate source systems.
- Actively monitor and report on end-to-end data flow from source systems to data warehouse.
- Monitor, adjust, and report on Snowflake “Compute” and “Storage” usage and capacity.
- Assemble performance statistics, analyzes, and makes recommendations for improvements.
- Establishes and maintains system documentation.
- Participate as active member of Data Governance Committee.
- Actively work with Institutional Research on appropriate use of datasets in Tableau and other analytical tools.
- Serve as primary interface with the Business for the purpose of requirements gathering, design, testing, and other project related activities
- Proven ability to understand business needs and translate them into technical requirements
- Perform related duties as assigned.
Minimum Qualifications: : A minimum of a Bachelor’s Degree in an applied technology area such as Information Systems or Computer Science and 5 years work experience supporting relational databases and/or data warehouses.
Job Type: Full-time
Pay: $49,836.00 - $100,568.00 per year
Schedule:
- 8 hour shift
Experience:
- Data modeling: 1 year (Preferred)
Work Location: One location
Database Administrator Analyst, Remote PA
NTT DATA -
Blue Bell, PA
Service Desk Analyst
Data-Core System, Inc. -
King of Prussia, PA
IT Service Desk Analyst
Data-Core Systems Inc -
Wayne, PA