The Customer Analytics team is dedicated to empowering the Customer Services organization with actionable insights. The team analyzes data, identifies trends, and provides strategic recommendations to enhance customer satisfaction, optimize processes, and drive informed decision-making. The team's mission is to enable exceptional customer experiences through data-driven excellence.
As an Analytics Developer/Data Engineer on this team, you will work on dashboards, interactive visualizations, data pipelines, and reports. The successful candidate will utilize their experience with all Business Intelligence (BI) domains from translating requirements to sourcing, profiling, and modeling data, to ETL and dashboard development. This role will work closely with business partners to develop and implement analytical data models and dashboards. To excel in this role, the candidate should complement their analytical skills with a technical understanding of data pipelines and be versed in multiple data systems.
This role will be split 75% analytics development, 25% data engineering. You will work alongside Data Scientists, Business Representatives, Data Engineers, Programmers, and Analytics Developers.
What You'll Do
Define and develop dashboards including business metrics and performance indicators that drive action and insights (PowerBI experience preferred)
Build and maintain ETL pipelines utilizing data migration services (SSIS, Azure Data Factory), languages, and tools that connect various data sources (Snowflake, SQL, DB2)
Apply query, data exploration and transformation, basic statistical methods and visualization techniques to create business insights or improve data quality
Write, implement, and schedule ETL and other operational packages and scripts using SSIS and SQL
Collaborate with operational/IT business leads to recognize and help adopt best practices in data delivery, analysis, integrity, and validation.
Experience in performance tuning and query optimization
Ability to analyze and design physical databases and their definitions
What It Takes To Succeed
The successful candidate will possess these capabilities:
Advanced proficiency with PowerBI
Strong proficiency with T-SQL in a SQL Server environment
Experience coding ETL processes in SSIS and Azure Data Factory
Expertise in modern database technologies, data integration, reporting
Solid understanding of data warehousing concepts and data modeling (Prefer 3+ years)
Strong critical thinking, problem solving, organization and analytical skills
Demonstrated ability to communicate and present analysis or technical concepts to a non-technical audience in a clear and understandable manner
Desired Technical Skills:
Development/Query languages: SQL (T-SQL, PL/SQL, SnowSQL, etc.), Python
Platforms/Tools: PowerBI, Snowflake, Microsoft Azure, Dataiku, Azure Data Factory, Legacy Databases (SQL Server, DB2, Oracle), SSIS, SSRS
Knowledge of SAP and its data-related tools (Datasphere, Analytics Cloud, etc) is a plus
Prefer degree in Computer Sciences, Information Technology, Computer Engineering, Analytics, or related discipline.
Experience
Promotion to Level 2 requires a minimum of two years experience at Level 1 and demonstrated capability to perform advanced and more difficult work as determined by the supervisor. Promotion to Senior Level requires a minimum of 3 years experience at Level 2, is fully competent in all aspects of functional area of assignment and as such would be recognized as a specialist in area of assignment and may have periodic or occasional lead responsibilities.
Education
Completion of a Bachelor's Degree from an accredited institution that prepares the employee for the assignment.
SRP
Arizona United States
www.srpnet.com
