Developer

Hi,

Hope you are doing good, This is Rajeev from FutureTech Consultants, LLC and I have a job opening with our direct client.

Please have a look at the below job description and let me know your interest. Please share me the latest copy of your resume.

Role: BI Dashboard/Report Developer

Location: Sacramento, CA 95814 (ONSITE)

Duration: Long Term Contract

Manager Notes:

• We have to look for candidates that must have expertise in Oracle Autonomous Data Warehouse in the Oracle Cloud Infrastructure AND Microsoft SQL Server 2022 on the customer s premises and in the Microsoft Azure Cloud.
• Also target for mentioned certificates as well.
• The services shall be performed at Caltrans Headquarters located at 1120 N Street, Sacramento, CA 95814 and other locations within 20 miles of Sacramento, or remote at the direction of Caltrans
• Staff shall work at Caltrans HQ (Sacramento) at a minimum of two (2)-three (3) days/week.
• Due Date: RFO Submission due on or before 6/13/2024 at 12:30PM

Background:

Caltrans has an Enterprise Data Warehouse (EDW) Department-wide Business Intelligence (DBI) office and is looking for skilled professionals to provide operational support for data analysis, data modeling, data extract, transform and load, database administration, data warehousing, predictive modeling, developing web applications, dashboards, and reports in Power BI to support business programs and districts in decision making.

Caltrans is seeking IT Consultants that must have expertise in Oracle Autonomous Data Warehouse in the Oracle Cloud Infrastructure AND Microsoft SQL Server 2022 on the customer s premises and in the Microsoft Azure Cloud.

Mandatory Qualifications:

• Staff resource must have a minimum of five (5) years of working experience with Oracle Analytics Cloud (OAC) and Microsoft Power BI with a sound knowledge of database management, data modeling, business intelligence, SQL querying, data warehousing, and online analytical processing (OLAP)
• Staff resource must have five (5) years of experience working with OAC and Power BI. This experience should include monitoring the performance of reports and taking corrective action to optimize or improve the performance of the reports when necessary.
• Staff resource must have experience with self-service data preparation using OAC and Power BI dataflows. Familiarity with integrating OAC/Power BI dataflows and applying ETL at scale and setting up dataflow refresh schedules.
• Staff resource must have a minimum of three (3) years of verifiable experience specific to Power BI and/or Tableau report and visualization development.

Desired Qualifications:

• Familiarity with data governance, data security, and data privacy regulation.
• Basic understanding of measures and facts as frame for interacting with data.

Job Responsibilities:

• Develop, test, and implement dashboards and reports from data within the Oracle Autonomous Data Warehouse utilizing either Oracle Analytics Cloud (OAC) and/or Microsoft Power BI.
• Understand the Business Users requirements in OAC/Power BI context and design data models to transform raw data into meaningful insights.
• Develops Testing Approach, Plan, and Documentation of Results.
• Develops Requirements Specifications (e.g. ability to publish to web, identification and protection of PII data, etc).
• Develops Design Specifications.
• Develops a feedback mechanism to allow users to report issues with existing reports.
• Builds and maintains report catalog.
• Gathers feedback to improve and expand on existing reports to better meet business needs.
• Conduct performance tuning and optimization of dashboard and reporting solutions for efficient and effective data retrieval and visualization.
• Understands best practices for report lifecycle management, version control, and data governance.
• Creates a user interface to ensure reports and dashboards are organized and easily accessible.
• Ensures report availability and performance.
• Mentors and educates team members on best practices and industry standards.

Regards

Rajeev Mudakala

Sr. Talent Acquisition Specialist

FutureTech Consultants, LLC

5655 Peachtree Parkway, Suite 212, Peachtree Corners, GA 30092

Direct:

&

• Dice Id: 10107680
• Position Id: 8309247