Data Governance Engineer Consultant

Sogeti, a subsidiary of Capgemini, is seeking a dynamic and experienced Consultant to join our team in Dallas, Texas. With a strong emphasis on our people and partnerships, we foster a "People centric" culture where innovation thrives.

Sogeti is a wholly-owned subsidiary of Capgemini and the Technology and Engineering Services Division of Capgemini. We have more than 25,000 professionals in 15 countries and has a strong local presence in over 100 locations scattered throughout the US, Europe and India.

We are leading provider of technology and software testing, specializing in Application, Infrastructure, Data, Analytics and Engineering Services. We offer cutting-edge solutions around Testing, Business Intelligence & Analytics, PLM, Mobile, Cloud, and Cyber Security, combining world class methodologies and its global delivery model, Rightshore®. Sogeti’s roots and the bedrock of our success lie in the provision of local professional services - teams of experienced IT professionals working closely with local clients.

We offer an environment that celebrates innovation and helps you to achieve a good balance between your professional and personal life. We strive to be THE employer of choice!

*Although with Capgemini/Sogeti we can often offer visa sponsorships - we do not have time with this opportunity to complete a transfer. Please feel free to apply though and note that you require the transfer as this role does come up often so there may be more opportunities in the future.

What you'll do:

Drive business teams to understand business process and data flows. This consultant will document results of data profiling to facilitate decision making with executive and senior business data owners. Additionally, this person is required to provide expertise in analytics and visualization as it relates to clients' enterprise data warehouse and business line data marts.

In this position, the Senior Data Analyst/Engineer is hands-on in developing and publishing analysis artifacts as well as is a mentor to other analysts on the Enterprise Data & Analytics Team. The Senior Data Analyst will contribute to or provide leadership oversight to data solutions in the following three areas:

• Implementing data quality management, including the development of the data quality rules for critical data elements based on the selected data quality dimensions and designing the data quality results database, dashboard, integration with our business glossary, and the automation of the process
• Implementing enterprise data warehouse solutions, including the analysis for source systems, source to target mapping, and built-in data quality
• Assist with Data Governance, including the data profiling for source systems, critical data element identification, and business glossary management

This exciting opportunity requires the best of your data analysis, problem solving and collaboration skills. The Senior Data Analyst will contribute to the development of cross-business unit data solutions that are leveraged to improve our products and insights.

The ideal candidate has strong business and technical analysis experience, a growth mindset, is outcome-focused, and fosters teamwork.

Essential Functions:

• Partner with the Data Product Manager, Data Architects, and Data Engineering Manager to ensure data analysis is addressed in the product development lifecycle
• Develop, implement, and support the processes and best practices for data exploration, data profiling, data quality and data mapping required for the tactical implementation of the Client's data strategy and roadmap
• Collaborate with business data owners to execute data profiling and source data analysis for critical Western Alliance Bank applications and systems
• Participate in data governance activities by partnering with the Enterprise Data Stewards as required
• Participate and contribute to the data issues resolution process within our Data Governance function
• Develop and manage the data lineage, business rules (data quality, cleansing, transformation rules, etc.), reference data, and mapping documents across the enterprise in the Metadata Management Tool
• Apply data analysis skills to the data quality/data governance process and/or to the data flows required to engineer the enterprise data warehouse
• Prepare analysis findings and communicate to both business and technical stakeholders
• Create data visualizations to explain data analysis recommendations

Minimum Qualifications

• Bachelor’s Degree in Engineering, MIS, or Data & Analytics or equivalent experience
• 5+ years’ experience with data analysis specifically as it relates to enterprise data management including data warehousing and source to target mapping
• Strong experience with RDBMS and query language such as T-SQL, PL/SQL, Spark SQL
• Strong experience using analytics tools such as SPSS, SAS, Tableau, PowerBI
• Strong experience using data profiling/wrangling tools (Example: IDQ (preferred), Alteryx, Paxata, Trifacta, Tamlr, etc.)
• Strong experience using common file formats such as CSV, TEXT, JSON, XML, XSD, etc.
• Excellent problem solving and analytic skills
• Excellent communication skills, both verbal and written, and ability to work collaboratively within a team, business stakeholders and executives

Preferred Qualifications

• Experience in Agile, SAFe, and/or Scrum
• Experience working in a data governance function
• Experience integrating with data quality, data catalog and data lineage tools is a plus
• Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer
• Banking or financial services industry experience or other highly regulated industry experience
• Experience integrating and using data science or statistical solutions

Join us at Sogeti and become a part of a culture that celebrates innovation and fosters work-life balance. We strive to be the employer of choice, offering a supportive environment for professional growth and development.

Minimum Education Qualifications:

Bachelor's Degree in Computer Science, Computer Engineering, MIS or related field.

Compensation

Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $80,000 - $150,000.

This role may be eligible for other compensation including variable compensation, bonus, or commission.

Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees. Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.

Disclaimer

Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.