Software Developer, Data Analyst, Data Engineering

Software Developer Job Description

The Software Developer will perform the following job duties under the supervision of senior developers:

• Assist in developing and modifying software solutions by building and maintaining Power BI reports and dashboards using established data models, simple DAX measures, and guided ETL processes.
• Design, implement, and maintain interactive BI dashboards and reporting solutions using Microsoft Power BI. Configure dashboards that present operational metrics, performance indicators, and analytical summaries through structured visual components including KPI cards, matrices, bar/line charts, and time‑series visualizations.
• Utilize enterprise data models and Data Analysis Expressions formulas to calculate aggregated metrics such as totals, averages, ratios, and trend‑based indicators.
• Configure data refresh pipelines and apply transformation logic in Power Query to support automated ETL workflows that synchronize dashboards with enterprise data sources.
• Analyze information from multiple sources (Excel, Salesforce, SQL databases, SharePoint, AWS S3) and integrate data into existing Power BI and Salesforce reporting applications following team templates.
• Retrieve and analyze structured datasets from multiple enterprise platforms including spreadsheets, CRM systems, relational databases, collaboration platforms, and cloud storage repositories.
• Access datasets from Excel files, Salesforce repository objects, SQL database tables and views, SharePoint document libraries, and cloud‑based storage buckets hosted in Amazon S3.
• Utilize Power BI data connectors and SQL‑based queries to extract relevant datasets, perform data preparation tasks such as schema normalization, datatype conversion, duplicate removal, and relational joins, and construct integrated data tables to support centralized analytics and enterprise reporting solutions.
• Use expertise in various design patterns and integration options, including native Salesforce APIs and external solutions.
• Confer with program managers and stakeholders to clarify reporting requirements; create or update standard recurring reports and respond to routine ad‑hoc data requests using Power BI, Excel, and Salesforce tools.
• Develop recurring reports and dashboards that summarize metrics such as operational performance, program utilization levels, project status indicators, and departmental outcomes.
• Generate ad‑hoc analytical reports and custom visualizations using Power BI, Excel, and Salesforce reporting tools; produce filtered datasets, summary aggregations, and visual analytics to allow stakeholders to evaluate trends, compare historical performance metrics, and analyze operating data across reporting periods.
• Automate file handling and processing for archival in AWS S3 and Connect.
• Correct errors and improve functionality of existing reporting workflows by testing dashboards, fixing basic data refresh issues, and automating routine file uploads and downloads to AWS S3 using provided scripts.
• Perform validation testing and troubleshooting for dashboards, reporting logic, and automated data refresh processes.
• Analyze data refresh logs and reporting outputs to identify inconsistencies and other discrepancies; implement corrective updates to transformation logic, DAX calculations, configuration settings, or dataset relationships to maintain reporting accuracy.
• Support automated data processing pipelines by executing scheduled scripts and workflows that upload and retrieve structured data files between enterprise systems and AWS S3 storage environments to ensure reliable data availability for reporting applications.

• Degree
  :
  Bachelor's
• Majors
  :
  Computer Science (or related)
• Job site
  : 101 Parkshore Drive, Suite 100, Folsom, CA 95630