Sr. Data Analytics Engineer

Description : POSITION SUMMARY

POSITION SUMMARY

Client is looking for a highly motivated, and experienced Senior Data Analytics Engineer to provide quality and performant data modeling and visualizations solutions to our cross functional business units which represent the mantra, Business First;

Technology Second. You will join a results-oriented team and participate in the design, implementation, maintenance and support of our modernized data platform to enable the business to make better, more informed decisions.

This is a key role in the Data Analytics team and will work closely with Enterprise Data Analysts, Data Platform Engineers, Data Governance Team within Enterprise Data Management Org.

In this role you will help define, develop and implement solutions and provide services for the enterprise applications.

Some of the Projects you will work on including but not limited to :

• Build Data products to elevate and enable our America’s Executive DTC (Direct to consumer) Leadership and Product Team.
• Enterprise Top Dashboard : Build out the management reporting layer, identifying and developing the UA Top management dashboards.

To transform Client into a more data driven organization, enabling faster and better decision making and reducing the reliance on manual, labor intense reporting.

End to End Planning Transformation Project.

ESSENTIAL DUTIES & RESPONSIBILITIES

To perform this job successfully, an individual must be able to perform each essential duty

satisfactorily. The requirements listed below are representative of the knowledge, skill, and / or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Model, design, develop, test and implement the appropriate backend and front-end structures needed to meet business visualization and reporting requirements.
• Leverage industry-leading integration and analytics tools to build a modern data warehouse that is accurate, reliable, high performing and easily accessible to our business departments.
• Build dashboard to follow wireframes designs, integrate with backend data models. Build

aggregate data models. Manage the data flow to reflect in dashboards to meet business

requirements.

Data formatting and processing to build the foundation layer for dashboards and self-service reporting. Work on data transformation, using the ETL tools.

Build dimension views and fact tables.

Interact with the client business community to gather / develop functional and technical

requirements and translate them into reporting solutions.

• Responsible for the full life cycle of development, from requirements gathering through data transformation coding and report / dashboard design and creation.
• Follow development standards in accordance with UA best practices.
• Work with Enterprise Data Analysts team to clarify functional requirements and create the

TSD''s.

• Data formatting and processing to build the foundation layer for dashboards and self-service reporting.
• Troubleshoot data anomalies with engineering teams.
• Work on data transformation, using the ETL tools. Build dimension views and fact tables.
• Responsible for daily support of the data warehouse and associated data marts
• Coordinate with Data Platform Engineering team, Enterprise Data Analyst Team, Data

Governance Team, and IT Teams to align with change management processes and to ensure performance, processes and access is optimal for our global reporting solutions.

• Work collaboratively to align business requirements with reporting and analytical solutions.
• Improve processes regarding data flow and quality to improve data accuracy, viability and

value

• Document development for peer reference and knowledge transfer.
• Interact with the client business community to gather / develop functional and technical

requirements and translate them into visualization solutions.

Educate and empower the business community towards self-serve reporting model.

QUALIFICATIONS (KNOWLEDGE, SKILLS & ABILITES)

• Proven ability to express complex technical concepts in business terms
• Exceptional team player with excellent interpersonal skills.
• Possess excellent organizational skills with the ability to manage multiple responsibilities
• Comfortable working in a fast-paced, dynamic environment and committed to meeting

deadlines

• Deep analytical, planning and problem-solving skills are required.
• Excellent verbal and written communication skills.
• Must be a self-starter, proactive and possess the ability to work with minimal supervision

EDUCATION AND / OR EXPERIENCE :

Bachelor’s degree in Information model development and data warehousing or Computer

Science, Computer Engineering or a degree to include similar major.

• Fundamental data architecture and design skills
• Excellent knowledge of SQL and strong data transformation skill.
• 3+ years of Experience in design and development of analytical queries, reports and

visualizations utilizing the Tableau Platform.

• 3+ years of Experience with dbt or similar data orchestration tool.
• 2+ years of Experience working in CICD framework.
• 3+ years of Experience with Snowflake VWH and data modeling.
• Familiarity with HVR replication or similar tools for data ingestion.
• Demonstrated knowledge* of :
• Python and SQL programming.
• Fundamental data architecture and design
• SQL and strong data transformation
• Not Required but DBT / Snowflake certification
• Enjoy working with emerging technologies.
• Comfortable with language barriers or constraints; bilingual language skills are a plus

OTHER REQUIREMENTS :

• Program Experience : IE- Microsoft Suite, Adobe, Sprinklr
• Licenses / Certifications

RELOCATION :

• No relocation provided
• Only those lawfully authorized to work in the designated country associated with the position will be considered.
• Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.

Benefits :

For information and details on employment benefits offered with this position, please visit

here

Should you have any questions / concerns, please contact our HR Department via our secure

website

California Pay Equity :

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website

here

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law.

Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise,

please contact our HR Department

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.

S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13 / 10-91.).