Job Description

Job Title: Sr. Data Engineer

Division: Class Action & Corporate Restructuring

Department: Data Services

Location: Hyderabad

Reports To: Senior Product Development Manager

Summary

- The Data Management team within Data Services is growing and we are looking for Data Engineers. This position will be key position of Data Management team.
- The Data Engineer will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up.
- The Data Support team’s focus is on building systems/solutions to aid the rest of the organization in consuming data.In practical terms, we are focused on establishing, building and maintaining the data ecosystem so that the rest of the organization has the information available that they need.This includes providing reporting/analytics tools/support.
- The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives, and is comfortable with collaborating as part of a larger group to identify appropriate solutions.

Job Responsibilities:
- Create and maintain optimal data pipeline architecture
- Assemble large, complex data sets that meet functional / non-functional business requirements
- Identify, design, and implement internal process improvements: automation of manual processes, optimization of data delivery methods, re-design of infrastructure for greater scalability, etc.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics
- Work with key stakeholders to strive for greater functionality in our data systems
- Serve as a Subject Matter Expert (SME) regarding data architecture, as well as proper data collection and storage methods.

Qualifications

- BE/B.Tech/MCA Computer Science or related discipline, or equivalent industry experience
- 5+ years as a software developer and/or SQL developer designing and building software and database solutions using SQL Server 2008R2 or newer
- Demonstrated experience designing and developing medium to large-scale, mission-critical database solutions, to include the following strengths: Thorough understanding of Kimball/Inmon strategies, key performance indicators (KPI) Reports, and data mining structures
- Expert data modeler and proficient with modeling tools
- Extensive knowledge of data normalization concepts, Relational Database Management Systems, data warehouse systems, and star schemas
- Expertise with Index management: creation, maintenance, and tuning
- Extensive experience in SQL Server Business Intelligence Development Studio(BIDs):
Integration Services (SSIS)
- Extracting, Transforming, and Loading (ETL) data from MS Excel, flat files, or other sources to SQL
- Reporting Services (SSRS)
- Creating simple and complex reports in SSRS, including matrix / pivot outputs, charts and graphs, Drill Through and Drill Down
- Extensive experience with T-SQL, including but not limited to:
Troubleshooting, Triggers, Stored Procedures, Functions, Views, Performance tuning,
- Experience developing dashboards and other macro-level outputs using Power BI or similar business intelligence tools
- Excellent communication skills; ability to express complex ideas in writing at appropriate level of detail for intended audience; fluent in English
- Team player, willing to engage within and across the organization
- Ability to support data needs of multiple initiatives, systems, and products concurrently in a fast-paced environment
- Self-directed professional who seeks out opportunities and areas where improvements can be realized
- Passionate about technology, automation, and eliminating human toil

Competencies:

Integrity – Behaves in an honest, fair and ethical manner; shows consistency in words and actions; does what she/he commits to doing; respects the confidentiality of information or concerns shared by others; is honest and forthright with people; carries his/her fair share of the workload; takes responsibility for own mistakes.


Client Focus – Takes action with the clients, both internal and external, and sees their needs as a primary focus; builds a sustaining collaborative and productive relationship with clients; seeks to understand client situations, issues, expectations, etc.; takes appropriate action to meet client needs and address concerns; implements or utilizes methods to monitor and evaluate client feedback.


Results-Driven – Sets stretch goals for personal and team accomplishment and works tenaciously to achieve those goals; acts with a sense of urgency; takes the initiative on actions; identifies what needs to be done and takes action before being asked; does more than what is normally required in a situation; establishes metrics to monitor progress and measure success; maintains focus by avoiding or overcoming roadblocks.


Entrepreneurial Orientation – Proposes innovative business opportunities/ideas to customers and business partners; encourages and supports entrepreneurial behavior in others; demonstrates willingness to take calculated risks to achieve business goals.


Decisiveness – Makes well-informed, effective and timely decisions even when data is limited or solutions produce unpleasant consequences; perceives the impact and implications of decisions; has the ability to make tough decisions.


Work Environment

Work is fast-paced and performed in an office environment with extensive contact with clients and employees. The industry we serve demands the highest level of confidentiality and professionalism in safeguarding client and project information. Highly effective Class Action & Claims Solutions and Corporate Services associates thrive on being in an environment that rewards the following critical success factors:


Adaptability: Appropriately reacting to changing situations without a loss of effectiveness and enthusiasm for strategic initiatives and corporate goals.
Analysis: Identifying problems and causes or analyzing how processes and procedures could be improved, collecting relevant information and identifying possible solutions.
Attention to Detail: Appropriately completing all of the individual tasks accurately or according to workflow/process guidelines with an emphasis on reaching or exceeding quality standards.
Creativity: Being inventive, imaginative and innovative. Development of Others: Providing the means for others to grow and develop personally and professionally within and across departments.
Energy: Maintaining a fast, active pace in the normal course of a day.
Flexibility: Going into situations without preconceived notions with a willingness to assess various options in order to determine a course of action.
Integrity: Strict adherence to job-related standards, values or norms.
Learning Ability: Understanding and applying new information. Listening. Hearing and comprehending verbal messages and confirming back what you hear.
Team Player: Functioning as an active member of a group while maintaining focus on your individual contributions and responsibilities. Verbal & Written Communication: Effective oral, written and nonverbal expression without preparation.


Physical Demands

The work environment characteristics described here are representative of those an associate encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essentials functions.

- Position requires no significant manual labor.
- Position does require moderate standing, sitting, carrying and walking.
- Position requires infrequent lifting, repetitive bending and/or moving.
- Position requires close vision, distant vision, peripheral vision, and depth perception.
- Position requires talking and listening to communications with clients and employees.