Analytics Engineer responsible for data consolidation and maintenance, supporting reporting and dashboards at Brilliant Corners for vulnerable populations.
Responsibilities
Design, develop, implement, and maintain data models used for reporting and analytics.
Work with Data Analysts and other business teams to identify and develop ETL/ELT processes to automate, orchestrate, and maintain data pipelines.
Maintain data documentation and definitions, including data quality standards and business logic for metrics/KPIs, naming and formatting conventions and detailed specifications/documentation for analytics code.
Maintain version control for, test, and continuously integrate analytics code into testing and production environments.
Monitor data models and pipelines to ensure performance meets internal service level agreement.
Collaborate with Data Analysts to build dashboards and visualizations that show trends, patterns, and outliers in the data pipeline and models. As well as, maintain current inventory of reports and dashboards and publish this information to business users.
Work with Product Development and other business teams to consolidate and integrate data from and between multiple data sources (such as Salesforce, Financial Systems, HRIS, and other data sources).
Maintain and update (as necessary) existing integration infrastructure, with a focus on streamlining and consolidating processes.
Help evaluate and validate new and existing tools or development needs to suggest improvements and streamline operations.
Support updates/upgrades, configuration and troubleshooting for business intelligence tools.
Help coach Data Analysts on software development best practices.
Requirements
Proven success in designing, building and maintaining data warehouse and infrastructure that meet business needs.
Experience with SQL.
Experience with Python or R.
Strong problem-solving skills in relation to data and software applications.
Excellent interpersonal skills and verbal/written/virtual communication skills to communicate technical details to both other team members and non-technical stakeholders.
Experience supporting and working with cross-functional teams.
Prior experience with software development best practices around code (version control using Git, testing, debugging, continuous integration and deployment, clear comments in code), especially implementing such practices in organizations.
Experience with cloud data warehouses and platforms like Snowflake, GCP, Azure.
Experience with ETL/ELT tools like FiveTran, Matillion, Stitch.
Experience with DBT, Dataform, Databricks.
Experience with data visualization tools like Tableau, PowerBI, Looker, Sigma.
Experience with Integration Platform-as-a-Service like Workato or Mulesoft.
Clear technical writing experience, including data mapping documents, reports, and presentations.
Experience in a non-profit, human services setting.
Senior Analytics Engineer designing scalable data models and optimizing data pipelines at Klar. Collaborating with cross - functional teams to ensure data quality and mentorship of business analysts.
Analytics Engineer Associate at Teragonia designing and developing advanced analytics for private equity clients. Collaborating closely with clients and team to deliver tailored solutions.
Engagement Manager leading a team of analytics engineers to develop advanced analytics solutions for private equity clients in Toronto. Driving value creation through innovative insights and strategic analytics.
Senior Analytics Engineer developing scalable analytics models for real - world health data. Leading strategic initiatives and mentoring teams in a hybrid environment in London.
Analytics Engineer making data an operational tool at Newsec's Göteborg office. Strengthening the use of data and collaborating closely with Product Managers.
Join knowmad mood as a Data Engineer / Analytics Engineer focusing on data processing for hotel business analytics. Collaborate within a mature data team on technological modernization strategies.
Senior Analytics Engineer at Simply Business designing data models and building infrastructure for AI and ML enhancement. Collaborating with engineering and product teams to integrate new data sources.
Data Analytics Engineer focused on building ETL pipelines and data models at Prodigy Finance. Working with AWS Redshift, Python, and SQL in a hybrid team.
Data Analytics Engineer driving innovative data solutions at Northern Trust. Collaborating on architecture, client satisfaction, and technology transformations with a global team in a hybrid role.
Analytics Engineer transforming raw data into actionable insights to support decision - making in data marketing. Working with various data technologies in a hybrid internship role in Paris.