- Identify customer requirements for specified projects.
- Evaluate requirements requests to determine feasibility and potential issues.
- Work with business stakeholders to assist with data modeling or outlining the data requirements to support our business processes.
- Create and improve data solutions that allow for smooth data delivery.
- Gather, process, maintain and analyze huge amounts of data.
- Design, automate and support sophisticated applications for data extraction, transformation, and loading.
- Develop source-to-target mapping, or data transformation instructions that outline how to convert data in the source system to the target system as well as map the data values.
- Use ETL tools to develop pipelines to transfer data between systems.
- Document ETL processes and data mappings between source and target systems, that can be consumed by other software development teams.
- Assess and plan for an organization's data storage requirements, considering factors like data volume, growth projections, and access patterns.
- Evaluate and recommend tools and technologies to enhance the data storage environment's development, maintenance, and performance.
- Identify, design, and implement internal process improvements such as automation of manual processes and the optimization of data delivery for greater scalability.
- Test databases and troubleshoot any issues.
- Ensure data accuracy and consistency.
Skills and Qualifications:
- Demonstrates working competency of technology stack associated with project solutions.
- Experience working with Enterprise Data Integration Tools like FME and Azure Data Factory.
- Experience working with implementations on the cloud using Microsoft Azure
- Strong oral and written communication skills demonstrating ability to share and impart knowledge.
- Experience implementing a medallion architecture-based data warehousing solution.
- Experience implementing advanced data modeling concepts such as star and/or snowflake schemas.
- Business analysis experience and ability to translate business needs and problems into viable/accepted solutions.
- Strong investigative, analytical, and problem-solving skills.
- Strong interpersonal and data analysis skills.
- Ability to be flexible when needed, take initiative, and demonstrate accountability.
- Ability to quickly adapt to new methods, work under tight deadlines and stressful conditions.
- Ability to set goals and handle multiple tasks, clients, and projects simultaneously.
- Ability to appropriately balance priorities, deadlines, and deliverables.
- Ability to work well within a team environment and participate in department/team projects.
- Ability to balance detail with departmental goals/objectives.