Junior Data Engineer / SSRS Developer

LCP TRACKER INC•Orange, CA

21h•$42 - $48•Hybrid

About The Position

The Junior Data Engineer/SSRS Developer is responsible for designing, building, and maintaining scalable data solutions that support reporting, analytics, and business decision-making across the organization. The primary focus of this role is on developing SSRS reports. Working in a Microsoft-based data environment, this role partners closely with business and technical stakeholders to ensure data accuracy, performance, and usability.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience.
2+ years of experience working as a SSRS Developer and/or Data Engineer.
Strong experience with Microsoft SQL Server, including performance tuning and query optimization.
Hands-on experience building ETL solutions using Azure Data Factory (ADF).
Experience designing and supporting Data Warehouse solutions.
Proficiency with SSRS and Power BI for reporting and dashboard development.
Experience with Azure Analysis Services (AAS) or similar semantic modeling tools.
Familiarity with cloud-based and on‑premise Microsoft data technologies.
Strong analytical, problem-solving, and communication skills.

Nice To Haves

Experience adopting AI‑first or AI‑assisted development practices

Responsibilities

Develop and support SSRS reports and Power BI dashboards, ensuring data is accurate, timely, and presented in a clear, business-friendly manner.
Design, create, and maintain SQL Server database objects, including tables, views, stored procedures, and functions.
Develop, maintain, and monitor ETL pipelines using Azure Data Factory (ADF) to ingest, transform, and load data from multiple sources into the data warehouse.
Build and maintain a centralized Data Warehouse to support analytics, reporting, and downstream data consumption.
Implement and manage Azure Analysis Services (AAS) models to support semantic layers and enterprise reporting.
Analyze and optimize SQL queries and data models to improve performance, scalability, and reliability.
Perform data quality assessments and proactively identify data integrity issues.
Collaborate with business users, analysts, and leadership to understand reporting and data requirements.
Establish and support data tools and reporting solutions for department and unit managers.
Document data pipelines, data models, and reporting solutions following best practices.
Stay current with Microsoft data platform features and recommend improvements to existing solutions.