OneMagnify is looking to solve the problem of translating business requirements into technical data specifications and supporting various data initiatives for their clients, by designing and supporting a set of data services and capabilities for their client's customers.
Requirements
- Advanced SQL scripting skills
- Python proficiency required
- Experience with GCP platform and tools associated with analytics and data
- Understanding of Snowflake platform a plus
- University or college degree in Computer Science, Mathematics, Engineering, Statistics, or related field of study
- 2+ years of relevant experience gathering and documenting requirements as well as technical specifications for data solutions
Responsibilities
- Leverage data tools and capabilities to deliver superior service to client's customers and to advance the Data & Analytics Road Map.
- Conduct discovery and end-to-end data analysis to understand customer needs and to help develop plans and activities to improve data quality.
- Elicit, analyze, interpret business and data requirements to develop complete data product solutions, includes review data models (entity relationship diagrams, dimensional data models), ETL and business rules, data management, governance, lineage, metadata and reporting elements.
- Manipulate large data sets using SQL to understand patterns in the data. Perform data profiling using various tools to learn the shape of the data to help inform data quality checks and/or curation rules that need to be developed.
- Apply statistical testing methodologies and create and maintain statistical data models to support data-driven decision-making and analysis.
- Support customers in interpreting data and remediating issues when required.
- Prepare technical specifications for data ingestion and transformation rules. Partner with data architects to build data models for efficient consumption of data.
Other
- Resourceful and relentless: independently capable of seeking information, corralling resources, and delivering results in challenging situations
- Collaboration and Teamwork: works with others to deliver results, contributing to the team and prioritizing group needs over individual needs
- Problem Solving: uses an organized and logical approach to find solutions to complex problems. Looks beyond the obvious to uncover the root cause of problems
- Open Communication: clearly conveys thoughts, both written and verbally, listening attentively and asking questions for clarification and understanding
- University or college degree in Computer Science, Mathematics, Engineering, Statistics, or related field of study
