Data Warehouse Developer, Senior

SENIOR DATA WAREHOUSE DEVELOPER

At Percepta, we bring first-class service across each market we support. As a Senior Data Warehouse Developer working remotely, you'll be a part of creating and delivering amazing customer experiences, while also enjoying the satisfaction of being part of a unique culture

What You'll Be Doing

The Senior Data Warehouse Developer is responsible for designing new subject areas, implementing, and maintaining a data warehouse containing corporate performance information and operational information for all Customer Interaction Centers worldwide. This position will be responsible for data warehouse structure and all Extract, Transform and Load (ETL) functions from a variety of operational systems. The Senior Developer is also responsible for assessing, designing, implementing, and monitoring data ETL processes related to data warehousing system lifecycle for continuous improvement of the business intelligence systems across the enterprise.

Additionally, the Senior Developer will manage the analysis and design, as well as planning and performing all system testing. Assessing the performance and capacity requirements of the data warehouse, making key technology decisions, verifying that the implementation meets all user requirements is also required. Some other duties may include project timeline development and assistance, client interfacing, and development of business and user requirements. This position will also provide technical leadership and mentoring to other IT and business team members.

You will be a part of a fast-paced, entrepreneurial environment, which thrives on delivering transformational solutions and maximizing value to their stakeholders. As a leader of the cloud transformation process, you must be passionate about data, be a change agent and mentor, and a strong collaborator with the various business and technology leaders. This opportunity will challenge both your technical skills as well as your creativity with an element of fun

The Senior Data Warehouse Developer is responsible for the design, development, testing, production launch, and ongoing support of Global Data Warehousing, Operational and Reporting applications. The Global DWH gathers data from many diverse Percepta and Client source systems including multiple Customer Relationship Management (CRM), Telephony ACDs, After Call IVR Customer Satisfaction surveys, E-mail Customer Satisfaction surveys, Quality Systems, Voice Mail and Work Force Management. These global DWH solutions support North America, UK, Germany, South Africa, Australia, and APAC regions.

During a Typical Day, You'll

• Provide Technical Leadership for design, development, testing, production launch, and ongoing support of Global Data Warehousing, Operational and Reporting applications. Develop and support Global DWH metrics required by the client's Program SOW's.

• Design and develop high volume data ingestion components and ETL solutions to collect data from various internal and external sources.

• Use tools in the cloud data warehouse development and deployment such as ETL tools, data quality and cleansing tools, query/reporting tools, OLAP, data mining, etc.

• Extract, Transform and Load (ETL) functions from a variety of operational systems.

• Strong experience in Power BI data modeling, analysis, and visualizations.

• Ensure data accuracy and reliability of the data presented in the Power BI reports and dashboards.

• Work closely with business stakeholders, business analysts and data scientists to understand their data needs and deliver solutions that meet their requirements.

• Assessing the performance and capacity requirements of the data warehouse.

• Assessing and ensuring all operational aspects of the data warehouse, including availability, data integrity, data feeds, etc.

• Verifying that the implementation meets all user requirements.

• Make key technology decisions related to Global DWH and Enterprise Systems applications.

• Mentor and assist in technical development of other technical staff.

• Other duties as assigned.

What You Bring to the Role

• BS in Computer Science, Information Technology, Computer Engineering or Mathematics highly desired.

• Power BI certifications desirable.

• 10 years of experience developing Global DWH software including ETL, Logical & Physical data modeling, SQL & Data Access Optimization, and Reporting and Analytics experience. Data staging areas, Cleansing and transformation mechanisms, Star/Snowflake schemas, Business Intelligence delivery mechanisms.

• 5 years of experience with DWH Performance monitoring and implementing performance improvements.

• 5 years of recent experience with PowerBI Tabular and SSAS Multidimensional Data Models

• In depth (T-)SQL development knowledge. Experience with ASP.NET (C#,VB), VBA (O365), Python is a plus.

• Experience with customer contact centers and/or customer contact center technology preferred. Customer Relationship Management (CRM), Telephony ACDs, After Call IVR Customer Satisfaction surveys, E-mail Customer Satisfaction surveys, Quality Systems, Voice Mail and Work Force Management.

• Cloud System architecture experience as relates to Data Warehouse services and infrastructure, AWS preferred.

• Significant experience with Cloud Data Warehouse technologies and complex data models

• A proven track record for the successful delivery of cloud data warehouse solutions and related components

• Strong Global Data Warehousing Technical design, development, and production support skills

• Ability to develop complex data models (tabular, multi-dimensional, materialized views) reports and dashboards

• Excellent knowledge in SQL/DAX queries, functions, and metrics in Power BI.

• Knowledge of AWS, AWS Quicksight reporting, nice to have.

• Knowledge on MS Analysis Services.

• Must be a tenacious problem solver able to make routine decisions as well as after-hours support requirements.

• Good communications and listening skills are critical components of this job. Must be able to interact with development and infrastructure teams, business and vendors including the training and mentoring of team members.

• Excellent organizational and time management skills

• Accuracy and attention to detail

• Ability to work under minimal supervision as well as in a team environment.

What You Can Expect

• Competitive Salary with Incentives

• Health/Dental/Vision/Life Insurance

• Flexible Spending Account (FSA) and Health Savings Account (HSA)

• 401(k) with company match

• Vacation/Sick Time and Paid Holidays

• Tuition Reimbursement

• Employee Assistance Program

• Employee Discount Program

• Training and Development Programs (Percepta College)

• Employee Rewards Program (Perci Perks)

A Bit More About Your Role
Percepta supplies the equipment for this role. Occasional travel, weekend and after business hours work as necessary.

About Percepta
Established in 2000, Percepta has contact centers across the globe that proudly deliver a frictionless customer experience to our clients.

Our values are the heartbeat of our organization, and we live, breath and play by them every day. As a Percepta team member, you can expect:

Culture of Service - to be treated like you are the customer from day one

Teamwork - belonging to a supportive family team environment that encourages growth, fosters trust and open communication, and acknowledges value in your contributions

Respect - a team that is accountable, dependable and gives you their full attention

Proactive - to surround yourself with solution-oriented people who strive to improve themselves, others, and the organization

Career Growth - lots of learning opportunities for aspiring minds

Diversity - be a part of our growing diverse and community-minded organization that is all about having fun

Competitive Compensation - we take care of family, which is why we offer more than just competitive wages and great benefits. Our programs offer incentives and promote physical, mental, and financial wellness.

#LI-Remote

Percepta requires all employees hired in the United States to successfully pass a background check and depending on location and client program a drug test, as a condition of employment. Percepta is an Equal Opportunity Employer.