Senior BI / Data Analytics Engineer

Job Description

ADP is hiring a Senior BI / Data Analytics Engineer. In this position you will be 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. The percentages and weights described in the job description below may vary from organization to organization.
At ADP we are driven by your success. We engage your unique talents and perspectives. We welcome your ideas on how to do things differently and better. In your efforts to achieve, learn and grow, we support you all the way. If success motivates you, you belong at ADP.
We strive for every interaction to be driven by our CORE values: Insightful Expertise, Integrity is Everything, Service Excellence, Inspiring Innovation, Each Person Counts, Results-Driven, & Social Responsibility.
RESPONSIBILITIES:

• 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, SQL Server, 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.
• Expected to manage broader or multiple projects at a time.
• Acts as an expert source of technology and application knowledge within their domain technologies
• Participating in Business planning, IT strategy and setting direction
• Performs other related duties as assigned.

QUALIFICATIONS REQUIRED:

• 7-10 yrs of directly related experience in Data Analytics / Business Intelligence
• Minimum of 6 years of hands-on experience with SQL and RDBMS
• Minimum of 6 years of hands-on experience with data engineering including ETL and data warehousing
• Minimum of 4 years of hands-on experience with building semantic-layer business intelligence solutions including metrics, dashboards and data visualizations
• Expert problem solving skills to rapidly create ad-hoc queries to answer complex business questions or debug data issues
• Experience developing complex queries against normalized and dimensional data model
• Ability to work co-operatively as part of a team, as well as independently
• Excellent verbal and written communication skills

PREFERRED QUALIFICATIONS: Preference will be given to candidates who have the following:

• Bachelor's Degree or its equivalent in education and experience with a major area of concentration in Computer Science, Engineering or Math
• Working experience with AWS, Databricks, Snowflake, Tableau, Informatica or Alteryx
• Working experience with Python, Scala
• Working experience in the HCM software or financial industry

Explore our COVID-19 page https://jobs.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 ADP’s culture and our full set of values.