Job description

Position Overview: Design and create new financial reports, visualizations using Power BI, and workflows based on business logic as provided by managers through conversations with internal and external stakeholders. Create ad hoc reports and datasets based on data requests. Maintain/update current reports and workflows based on evolving needs. Automate current processes based on business logic as provided by manager or stakeholders. Ensure the integrity of data, including extraction, processing, storage, manipulation analysis. Troubleshoot and resolve Performance data-related issues. Ensure data system integrity within and across multiple sources (i.e., FINET, Utah Grants, Datawarehouse, Excel) Extracting data from various sources, including databases, spreadsheets and APIs. Designing and building interactive reports and dashboards using Power BI Desktop. Choosing appropriate visualizations (charts, graphs, tables) to convey insights effectively. Developing and applying complex calculations and measures using DAX (Data Analysis Expressions) language. Create, test, and support data models, structures, and processes for reporting analysis. Analyze advance A/B testing data. Publish reports and dashboards using Power BI. Transforming and cleaning data to ensure accuracy and consistency. Creating and managing data models for efficient analysis. Use SQL or BI tools to create queries and reports based on the star schema. Optimize SQL queries for better performance by analyzing query execution plans and making necessary adjustments. Conduct performance testing on Power BI reports and dashboards to identify areas of Improvement. Use Power Query to connect to data sources, retrieve data, and import it into Power BI. Cleanse and transform data using Power Query’s data transformation capabilities, including filtering, grouping, merging, and pivoting. Develop the relationships between fact and dimension tables and choose appropriate data types and ensure that the schema is designed for efficient query performance. Write complex SQL queries to retrieve, update, and manipulate data within the database. Create and maintain database schemas, tables, relationships, and constraints. Document report or process requirements by writing clear procedures and instructional manuals. Duration/Rate of Pay: 5 days per week, 40 hours/week, $120,000.00-130,000.00 per year Position requires Bachelor’s Degree (or foreign equivalency) in the field of Business Administration, Data Analytics, Information Technology or related fields. Send your resume to: Vertisystem, Inc. 39560 Stevenson Pl Suite #217 Fremont, CA 94539

Requirements

Must-haves

Duration/Rate of Pay: 5 days per week, 40 hours/week, $120,000.00-130,000.00 per year
Position requires Bachelor’s Degree (or foreign equivalency) in the field of Business Administration, Data Analytics, Information Technology or related fields.
Vertisystem, Inc.
39560 Stevenson Pl
Fremont, CA 94539

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: careers-html
Effort: medium