BI ETL Developer Job Listing at TCC in Fishers, IN (Job ID 8539)

Description

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.