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.
Analytics Engineer designing and developing software solutions for complex data at OCLC. Collaborating with teams to enhance data access and analytics capabilities.
Analytics Engineer enabling data - driven decisions across clinical and operational functions at QualDerm Partners. Responsible for data collection, analysis, visualization, and stakeholder collaboration.
Lead Digital Analytics Engineer driving modernization of site analytics and data layer for multi - brand ecommerce. Architecting a unified measurement foundation and collaborating with various stakeholders across the organization.
SAP Analytics Developer managing and delivering SAP BW/BI solutions for Niterra. Collaborating with stakeholders to optimize business intelligence and data warehousing capabilities.
ETL Developer maintaining data pipelines and supporting data quality for IMT Insurance. Collaborating with the data team and learning ETL tools under guidance.
Analytics Engineer creating scalable data models to support multiple products at Marshmallow. Collaborating across teams to enhance data - driven decision - making and optimize product offerings.
Analytics Engineer working in fintech, focusing on data modeling, SQL, and Power BI for strategic decisions. Engaging in high transaction volume environments with hybrid workspace setup.
Data Engineer transforming raw data into well - modelled datasets for decision - making at Blink. Collaborating with BI team to optimize and maintain data infrastructure.
Analytics Engineer responsible for transforming raw data and building robust data models. Collaborating with stakeholders to enable data analysis and directly impact decision - making processes.
Data - driven Operations Engineer at Octopus Energy Germany, optimizing processes using data insights. Collaborate with teams for sustainable energy solutions.