What are the responsibilities and job description for the Senior Reporting Services Analyst position at ACES?
Senior Reporting Services Analyst
Carmel, IN
This position is responsible for designing, building, and maintaining data workflows and pipelines that enable ACES and clients to collect, store, and analyze large volumes of data efficiently. Key responsibilities include developing and optimizing data pipelines to ensure the smooth flow of data from various sources through the entire reporting process, as well as ensuring data quality and integrity through validation, cleansing, and error handling. This role will interface and collaborate closely with data scientists and other stakeholders to deliver tailored solutions that align with business objectives. This involves transforming raw data into actionable insights through advanced analytics and ensuring that data pipelines deliver clean, structured data ready for analysis.
Duties and Responsibilities
Data Pipeline Development:
- Design, implement, and optimize end-to-end data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data using R.
- Develop robust ETL (Extract, Transform, Load) processes to integrate data from diverse sources into our data ecosystem.
- Develop and maintain internal R packages for quantitative analysis and factor building.
- Build and maintain integrations with internal and external data sources and APIs.
- Optimize data storage, processes and retrieval mechanisms for performance and scalability.
- Create and publish data-driven reports, dashboards, and web applications.
Data Infrastructure Management:
- Serve as a technical architect for Master Data Management initiatives.
- Monitor data pipeline performance, troubleshoot issues, and implement optimizations to enhance reliability and efficiency.
Data Quality and Integrity:
- Ensure data quality and integrity through data validation, cleansing, and error handling.
- Identify and cleanse any corrupt or outdated data to ensure accuracy.
Collaboration and Documentation:
- Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver tailored solutions.
- Document technical designs, workflows, and best practices to facilitate knowledge sharing and maintain system documentation.
- Provide technical guidance and support to team members and stakeholders as needed.
Qualifications
Educational Background:
- Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
Programming Skills:
- Proficiency in programming languages such as R, Python, and SQL.
- Proven experience in software development and data engineering
- Expertise in R package development and programming
- Experience with GitHub Actions for CI/CD workflows
- Strong knowledge of data modeling (OLTP/OLAP) and SQL query optimization
- Experience with columnar databases and ETL tools.
Analytical and Problem-Solving Skills:
- Excellent analytical skills associated with working on structured and unstructured datasets.
- Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement.
Communication and Collaboration:
- Effective communication and collaboration skills in a team-oriented environment.
- Ability to adapt to evolving technologies and business requirements.
