24 days old

Lead BI Solutions Analyst

Alpharetta, GA 30009

1. POSITION SUMMARY:

The business intelligence analyst job family is responsible for developing BI applications and solutions for ADP's external and internal clients. Business intelligence analysts may be involved in all aspects of the software development life cycle (SDLC). Business intelligence analyst's work with clients, product managers, analysts, architects and engineers to plan, design, develop, test and implement business intelligence solutions consistent with the business objective.

Business intelligence analysts may develop and review requirements, create design documents, write programs, package, test, configure and deploy software. Business intelligence analysts may also design and develop analytical data models to support static and ad-hoc reports, analytics and research, dashboards, data mining, trending, creation of key performance indicators, predictive modeling, etc. Business intelligence analysts may also design and develop extractors, transformations and loaders using ETL tools. Business intelligence analysts also participate and collaborate with other stakeholder including security, quality assurance, training, project management, engineering, hosting, & procurement when required to assist in other aspects of their projects.

Business intelligence Analysts at ADP are expected to be results-oriented, have knowledge of new and legacy technologies, have knowledge of the relevant platforms and environments, and be familiar with business process, functions and data within their domain to provide innovative, insightful, and secure solutions.

2. ESSENTIAL DUTIES & RESPONSIBILITIES:

Develop & enhance effective programs & data structures that successfully meet the objective.
Participate effectively in relevant aspects of software development life cycle (SDLC) including planning, construction, testing, reviews and demonstrations. Collaborate with team to design, develop, test and refine deliverables.
Investigate and resolve application issues as needed
Package, configure and deploying software
Collaborate with clients, Product Managers, Architects, & Analysts to develop and review requirements & design.
Review and create system, software and functional design specifications that address requirements.
Write scripts/procedures/statements using DML and DDL (SQL statements) against databases such as Oracle, SQLServer, DB2, etc.
Design and develop multi-dimensional data models using star and snowflake schemas, denormalized data structures, slowly changing dimensions, etc.
Use data architectural techniques such as enterprise data warehouse, data federation, hub & spoke architectures, independent data marts, etc.
Use data integration tools and techniques such as ETL (Extract Transform Load), CDC (Change Data Capture), etc.
Design and develop analytical data models to support static and ad-hoc reports, analytics and research, dashboards, data mining, trending, creation of key performance indicators, predictive modeling, etc.
Deliver BI content via portals, thin/thick clients, email, mobile, etc
Participate in project planning and release management. Higher level jobs would be expected to manage broader or multiple projects at a time.
Acts as an expert source of technology and application knowledge within their domain.
Research, recommend, and introduce new technologies and new uses of existing technologies
Participating in Business planning, IT strategy and setting direction
Performs other related duties as assigned.

3. EDUCATION & CERTIFICATION REQUIREMENTS:

Degree or Equivalent in Education & Experience : Bachelors
Major Area of Concentration : CS, Eng or Math

4. EXPERIENCE:

5-7 ears of directly related experience required.

 

Explore our COVID-19 page https://tech.adp.com/covid19/ to understand how ADP is approaching safety, travel, the hiring interview process, and more.

Diversity, Equity, Inclusion & Equal Employment Opportunity at ADP: ADP affirms that inequality is detrimental to our associates, our clients, and the communities we serve. Our goal is to impact lasting change through our actions. Together, we unite for equality and equity. ADP is committed to equal employment opportunities regardless of any protected characteristic, including race, color, genetic information, creed, national origin, religion, sex, affectional or sexual orientation, gender identity or expression, lawful alien status, ancestry, age, marital status, or protected veteran status and will not discriminate against anyone on the basis of a disability. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.

Ethics at ADP: ADP has a long, proud history of conducting business with the highest ethical standards and full compliance with all applicable laws. We also expect our people to uphold our values with the highest level of integrity and behave in a manner that fosters an honest and respectful workplace. Click https://jobs.adp.com/life-at-adp/ to learn more about ADPs culture and our full set of values.

Categories

Industry

  • Other
Posted: 2021-09-03 Expires: 2021-10-27
Sponsored by:
ADP Logo

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Lead BI Solutions Analyst

ADP
Alpharetta, GA 30009

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast