BI/Data Warehouse Analyst
samprasoftOcoee (FL)
About the role
Data Analyst Position Performs queries, analyses, and evaluation of data in a data warehouse environment. Uses data mining and data analysis tools to isolate and extract data based on specific parameters and monitors toll transaction data flow to identify any inconsistencies. Performs regular monitoring and trend analysis of system performance and Key Performance Indicators (KPIs). Recommends changes to systems or operations where needed. Reviews and validates data in the data warehouse for accuracy. Maintains knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments. Requires knowledge of, but not limited to SQL, Oracle, and other skills for large system monitoring. Experience with Intelligent Transportation Systems (ITS), Tolling, and PowerBI is a plus.
Education:
Bachelor's Degree in Computer Science, Information Systems, or other related field, or equivalent work experience.
Experience:
A minimum of 3 years of IT work experience in business intelligence tools and systems. Complexity: Intermediate professional level role. Provides data extraction, analysis, development, and support in multi-platform environments. Works on multiple projects as a team member and may lead projects of moderate complexity. May coach more junior technical staff.
Required Skills and Experience:
5+ years of experience as Data Analyst.3+ years SQL experience.3+ years Excel experience including functions and formulas.
Excellent analytical, problem-solving, and decision-making skill.
Willingness to learn new tools and skills and cross train.
Strong technical writing (reports and SOPs) experience, for all levels of the organization utilizing MSOffice, Visio, Share Point or similar applications.
Strong oral communication skills.
Ability to work on multiple projects across the organization collaboratively and proactively. Desired Skills and
Experience:
Experience with Power BI, Tableau, or similar BI tools.
Experience with Python.
Experience with MS SQL Server, Linux Unix background and PowerShell scripting.
Experience Windows server 2008 and above.
Experience of software and hardware testing.
Tolling experience.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.