Analytics Engineer
The Analytics Engineer will transform raw data sources into an intuitive data model that can be consumed by the organization. They are responsible for contributing to the work product of the Analytics Engineering agile team, adhering to the defined architecture best practices of the company, and producing deliverables that meet the customer and business objectives of a given project. The Analytics Engineer will execute work with speed and quality. Finally, the Analytics Engineer will communicate when they run in to issues that stand in the way of continuous productivity.
Essential Functions:
-
Contribute valuable work product as an Analytics Engineer on an agile development team. Runs queries to identify coding issues and exceptions. Completes tasks that are varied and require independent judgment.
-
Work closely with team leaders to understand all functional requirements. Develops/designs solutions based on established technical design with little guidance from others. Understands and applies functional area’s strategy. Prioritizes tasks and communicates status.
-
Creates documents independently with peer review. Documentation of design, development, integration/test and deployment activities. Documents processes and data dictionaries.
-
Provide support and maintenance for incidents and integrated solutions. Provides support and maintenance for complicated/integrated incidents. Troubleshoots moderately complex problems and recommends appropriate action. Evaluates risk potential and recommends solutions. Surfaces issues on the project that impede the progress of the team – solving those issues that are within your control.
-
Contribute to projects as a team member and participate in the agile process. Collaborates with other analytics engineers to improve systems and database designs. Involved in projects as a contributor and can lead small projects.
-
Contribute to an environment of mutual respect, accountability, excellence, and professionalism.
-
Assist in creating and maintaining a data pipeline architecture, work with stakeholders (e.g. business users, external partners, other IT staff) to understand raw data sources, contribute to data model that serves the organization’s needs, write reports that deliver insights to the organization, perform analysis to troubleshoot data related issues; also, assist in resolving production support issues, and assist in developing a data quality framework.
-
Other duties as assigned.
Education:
- Bachelor's Degree in Computer Science, Information Technology or other related degree required.
Work Experience:
- 4 - 6 years in the development and design of data pipelines for datasets.
Required Skills:
-
Understanding of ETL/ELT design patterns
-
Experience using RDBMS
-
Strong SQL knowledge
-
Ability to run queries to identify coding issues and exceptions
-
Experience writing/developing reports
-
Experience in source control practices
-
RESTful API concepts
-
Good understanding of agile development practices
-
AWS
-
Python
-
Big data technologies and concepts
Preferred Skills:
-
Experience working in a variety of development methodologies including Agile / SCRUM or other iterative methodologies.
-
Data discovery and BI software tools (e.g. Microstrategy, PowerBI).
-
Data matching concepts.
-
Experience building data transformations using dbt (Data Build Tool).
-
NoSQL databases
-
Data cloud solutions such as Snowflake.
-
Terraform
-
Jenkins
-
Experience performing statistical tests on large datasets to determine data quality.
-
Experience in data cleansing and data matching.
Other Requirements:
- Strong written and verbal communication skills. Strong organizational and analytical problem-solving skills. Ability to work on multiple tasks concurrently. Strong teamwork and interpersonal skills. Self-motivated with attention to detail. Strong time management, organization and meeting management skills. Ability to mentor and review the work of other Analytics Engineers. Ability to work as an agile team with both internal and 3rd party resources (onshore / offshore).