BI ETL Developer

POSITION PURPOSE

The Cellular Connection (TCC) is looking for fulltime resource who has solid experience in Business Intelligence solution development and support, including Data Profiling, ETL, and OLAP.

ESSENTIAL DUTIES

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions

Design & Develop ETL code utilizing Azure Data Factory

Support: Ability to trouble-shoot, triage Production Support data and report BI Solution issues (ETL, Cube, Reports)

Expertise in Azure tools, specifically Data Factory, Azure Analysis Services, Azure Automation - Runbooks /Workbooks and DevOps

Expertise in SQL - Queries, Stored Procs, Tuning

Data Profiling

Develop OLAP cubes

Translate business and functional requirements into technical requirements

Create unit test data and plans mapped to requirements, ensuring code and data quality

Execute unit test plans and document results

Support Integration Test and User Acceptance Testing with defect triage, and defect resolution for Data quality.

Understand and determine whether calculations and processing should be done in BI application or ETL

Monitor production loads, communicate issues to the team & user groups

Handle Stage and Production migrations and deployments

Document & maintain Production Support Runbook.

Ability to perform tasks following agile/sprint methodology

Experience with Data modeling against real-time (transaction system) source is a plus

Ability to handle BI support tickets

Provide estimation of software deliverables to management, highlighting risks and ensuring software is delivered as per Project plan REQUIRED KNOWLEDGE, SKILLS AND ABILITIES

The requirements listed below are representative of the knowledge, skill, and/or ability necessary to perform this job.

Skills and Competencies.

Proven ability to communicate well verbally and in writing, with all areas at TCC. Excellent communication skills are important - both written and spoken.

Ability to work independently, multi-task, and manage time and priorities to meet deadlines.

Strong collaborative, analytic skills to work with business partners to drive requirements for solutions

Mitigate problems and roadblocks, involving internal and external stakeholders.

Innovative mindset: ability to think both creatively and critically

Help create ad-hoc queries and provide data as requested, with a goal of transitioning to self-service

Routinely analyzes data across data lineage, from source to stage to target to reports

Able to evaluate priorities and manage work to critical project timelines in fast-paced environment.

Must demonstrate the ability to interpret business data and translate into insightful recommendations

Ability to prioritize and handle multiple tasks in high-pressure environment

Demonstrate leadership qualities, flexibility and adaptability in roles and responsibilities as required

Research and troubleshoot issues and questions related to deployed solutions

Maintain knowledge on the latest data technology and best practices EDUCATION

Bachelor's degree (B.A. / B.S.) in Information Technology or related field or the equivalent combination of education and experience.

EXPERIENCE

3 years of experience in Microsoft ETL (Azure Data Factory)

3 years of experience in Microsoft OLAP technologies (SSAS, Azure Analytics Services)

3 years experience in Azure databases (Azure SQL DB, Blob, Data Lake)

3 years of experience supporting a BI solution

Working experience with Agile methodology

Experience with Data Warehousing Modeling concepts PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

Typically works in a general office environment.

TRAVEL REQUIREMENTS

None.

JOB DETAILS:

Selected candidates MUST clear background check.

Level: Non-manager

Location: Fishers, Indiana KPI's

UAT issues error rate (due to code development issue(s)) <5%

Resolve Enterprise Reporting service tickets within 5 days >90%

BI System uptime 99% Equal Employment Opportunity We're proud to be an equal opportunity employer and celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status.

#ETL #BI #Newjob

Other details

Pay Type Salary