Enterprise Data Solutions Specialist

Job Title: Enterprise Data Solutions Specialist

Role Summary:

As an Enterprise Data Solutions Specialist, you will be responsible for designing and implementing data integrations from internal and external sources into a data warehouse technical stack. This role requires delivering accurate data to systems, building new ETL components, and making changes to existing software. You will also play a key role in designing and building a strong Enterprise Data Warehouse.

• Understand business and data requirements, define solution approaches, design, and implement ETL components.
• Demonstrated working knowledge of various business process and system modeling tools, including Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, and Use Case Scenarios.
• Develop Matillion ETL scripts and orchestrations as required.
• Ensure the team follows best practices of ETL development.
• Leverage monitoring tools to track the status of ETL pipelines for performance and completion.
• Develop and write complex SQL queries and stored procedures to extract and insert data into and from the data warehouse.
• Engage with Business Analysts and Technical Architects to clarify business requirements and offer recommendations for improvements.
• Contribute to defining a scalable data warehouse architecture.
• Coordinate production, development, and sandbox environments.
• Coordinate releases with DevOps teams and prepare documentation related to releases.
• Participate in peer code reviews.
• Provide coaching and guidance to junior team members on technologies and processes.
• Provide support and recommendations for testing and UAT for work being delivered.
• Provide out-of-hours support as requested for incidents.
• Participate in routine maintenance, performance tuning, and support of ETL and the DW environment.

• 2+ years of IT experience required in working with ETL in an enterprise environment.
• Knowledge in ETL Design methodologies including best practices, performance tuning, architecture, monitoring, and alerting.
• Knowledge of at least one ETL tool (SSIS, Informatica, Matillion, Talend, etc.).
• Experience with relational and dimensional data modeling and ability to represent data using standard modeling techniques.
• Proficient with SQL and stored procedures.
• Experience in working with at least one of these warehouse technologies such as SQL, Snowflake, AWS Redshift.
• Knowledge of processes when working on pre-release environments, moving changes between environments.
• Ability to deliver work to schedule (self-manage workload and priorities).
• Ability to work in a cross-functional team environment.
• Passionate about complex data structures and problem-solving.
• Ability to pick up new data tools and concepts quickly.
• Excellent written and verbal English communication skills.
• Amenable to work remotely.
• Amenable to work on EMEA Shift (4PM-1AM PHT).

• Experience with developing and testing APIs.
• Experience with Snowflake and/or columnar data stores.
• Experience with PowerBI.
• Experience designing and managing end-to-end business reporting, from data sourcing and mapping through to the production and delivery of reports.
• Experience defining, implementing, and building products and roll-out strategy for Data Quality, MDM, and Data Governance.

This role offers a unique opportunity to contribute to the design and implementation of a strong Enterprise Data Warehouse. As an Enterprise Data Solutions Specialist, you will have the chance to work on complex data structures and problem-solving, leveraging your knowledge of ETL design methodologies and data modeling techniques.

This is an exciting opportunity to join a team that values diverse perspectives and encourages innovation. If you are passionate about data solutions and have a strong background in ETL design and development, this role may be the perfect fit for you.