Vacancy expired!
- If selected, there might be a background check that includes a drug screen (usually 4-panel-excluding marijuana) and sometimes credit checks for financial clients.
- Most companies might also have a vaccine mandate, so once hired, we (or the client) will ask for proof of vaccination if required. If you are not vaccinated, we/they might ask you to work with them on a religious or medical exemption if necessary.
- This job has no supervisory responsibilities but provides technical leadership to lower-level employees. This includes, but is not limited to training employees, planning, assigning, directing work and resolving technically related work problems. It also includes interaction with other technical teams (e.g., server team, client team, applications team, support team, etc.). Additionally, the position will assist the manager in managing vendor relationships.
- NOT open to Corp to Corp.
- Those authorized to work in the US are encouraged to apply.
- We are unable to sponsor at this time.
- Design/Architect data warehouse, BI, and analysis services using Microsoft technologies (SQL, SSAS, SSIS, SSRS, Power BI)
- Generates ad hoc reports and regular datasets or report information for end-users using system tools, stored procedures, and database or data warehouse queries and scripts
- Integrates data from multiple sources (ETL-Extract, Transform and Load) to produce requested or required data elements
- Monitors daily ETL routines and troubleshoots / resolves any issues on a timely manner
- Programs and maintains report forms and formats, information dashboards, data generators, canned reports and other end-user information portals or resources
- Optimizes the performance of enterprise business intelligence systems and tools by defining data to filter and index that add value to the user
- Creates testing methodology and criteria
- Creates specifications for reports based on business requests
- Creates process flows, detailed design documents and end user procedures
- Leads training sessions for users in-house and remotely on various tool sets
- Drives strategic business decision making through detailed analytics, insights and real-time reporting on Key Performance Indicators (KPIs) and financial results
- Conducts data audits to verify data accuracy and ensures data quality
- Uses reporting tools such as SQL Server, SSIS, SSAS, Crystal Reports, Excel, etc.
- Develops standards, policies and procedures for the form, structure and attributes of the business intelligence tools and systems
- Develops data/information quality metrics
- Responds to high-priority, critical reporting requests as needed
- Daily availability to include evenings and weekends when necessary to reach goals and deadlines
- Bachelor’s degree (B.S.) from four-year college or university in a related field and 10-15 years of information technology experience with a programming or development focus and/or training; or equivalent combination of education and experience
- Full knowledge of professional concepts and the ability to use this knowledge toward development of theories and methods
- Strong interpersonal skills
- Strong oral and written communication abilities with all levels of management, employees, and customers, ability to communicate and explain information efficiently
- Ability to create clear and detailed documentation
- Can organize and write about projects and prepare and present a coherent, confident, concise and articulate briefing, with minimal review needed
- Proactively communicates knowledge to others, enhancing their work
- Answers questions clearly and succinctly
- Develops solutions to complex problems which require the regular use of ingenuity and innovation. Ensures solutions are consistent with organization objectives.
- Name:
- Best Contact Info:
- Your Linked In:
- Where do you live and your desired geographical location:
- Why looking for a new job:
- Availability for interviews and a new job:
- Willing to work 100% on-site or hybrid:
- Are you open to relocation if required:
- Do you have an active passport if needed for the job:
- Are you open to travel if needed:
- Are you authorized to work in the US (Please indicate US, , or Other):
- If not or do you require sponsorship at any time, or will you in the future?
- Salary Expectations: (We need a range) $
- Sizes of staff overseen and their titles: (include # of direct reports)
- Budgetary Responsibility: $
- Education/Certs/Degrees: (also indicate which certs are active )
- Who Referred You/ How Did You Hear About Job/ DKKD Staffing:
- Experience and/or the title of Business Intelligence (BI) Analyst/Architect:
- Advanced knowledge and thorough understanding of:
- Information technology reporting tools (SSRS and Power BI):
- Cube design and MDX (cube query language) and Tabular:
- Programming languages, such as SQL, TSQL, or PLSQL:
- Relational Database Design (3rd normal form):
- Relational Database mechanics (Indexes/Primary Keys/View/Stored Procedures/Functions):
- Relational vs multidimensional vs in-memory design concepts:
- A Tier I or II ERP system (Oracle, SAP, IFS, Dynamics AX …):
- Advanced skills using ETL tools (SSIS, Dell Boomi, Informatica …):
- Microsoft Office Suite (i.e., Outlook, Word, Access, Excel, PowerPoint, Project, Visio, etc.):
- IT security concepts:
- ID: #43304325
- State: California Elsegundo 90245 Elsegundo USA
- City: Elsegundo
- Salary: Depends on Experience
- Job type: Permanent
- Showed: 2022-06-19
- Deadline: 2022-08-16
- Category: Et cetera