Job Title Sr. Data Management Specialist
Date Posted 9/9/2021
Location Auburn Hills, MI
Status A
Job Type Contract Full-Time
Position Id 200593
Written By FB
Job Description Remote


The Senior Data Management Specialist will perform data analysis using a variety of tools and methods to provide technical assistance as a subject matter expert in identifying, evaluating and recommending data solutions that meet business requirements.
Responsible for understanding, analyzing, and documenting complex business processes & requirements which involve a broad understanding of the upstream and downstream systems, including impact and gap analysis of current data and reporting systems.
Review and provide recommendations on data validation and testing approach, systems testing and support, and data quality processes. In addition, provide training, resolve questions, and give direction to less experienced staff as well as providing support to the leadership team on achieving strategic and tactical goals regarding data.
We are looking for an experienced, energetic, and collaborative person who is passionate about data, understands technical tools and terminology, has business acumen, and can translate requirements into well written and concise documentation (stories).
• Design automated technical solutions for current manual processes (i.e. manual merging of Excel spreadsheets, MS Access databases and files)
• Understand complex business processes and relationships to determine downstream impacts to data and applications
• Identify areas for data quality improvements and helps to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies.
• Lead discussions with business partners to identify, understand, and document functional and non-functional requirements resulting in data acquisition or integration
• Provide data consulting services to application teams utilizing supported data environments
• Understand the existing source system data models
• Create source-target mapping documents and functional data specifications
• Participate in and support the full project life cycle (initiation, planning, requirements, analysis, design, development, quality assurance, user-acceptance testing, deployment, and production support)
• Ensure quality of master data in key systems, as well as, development and documentation of processes with other functional data owners to support ongoing maintenance and data integrity.
• Collaborate with subject matter experts and data stewards to define and implement data strategy, policies, controls, and programs to ensure the enterprise data is accurate, complete, secure, and reliable.
• Manage, analyze, and resolve data initiative issues and manage revisions needed to best meet business requirements while adhering to published data standards.
• Work within and across Agile teams to design, develop, test, implement, and support data analytics integration solutions.
• Document and support deployment activities.
Report on status of IT Data Operations products and projects on a regular and timely basis.
Strategic Work – 25%
• Educate and inform yourself and team members about data integration technology solutions and emerging trends
• Continually participate in visioning exercises and contribute to the data strategy

Operational Work – 75% of time
• Provide expert-level consulting services regarding identification and resolution of highly complex data challenges and issues.

• Must be a team player. We not Me.
• Solid understanding and experience in both agile and traditional project development methodologies.
• Excellent interpersonal communication skills (both written and verbal).
• Negotiation and conflict resolution skills; ability to create an open environment where conflicts as to project priorities, scope and requirement decisions can be aired and resolved in an objective manner
• Demonstrated capability to work on several projects simultaneously
• Analytical and conceptual thinking – using logic and reason, creative and strategic
• Integration – joining people, processes or systems
• Performance driven
• Intermediate to Advanced skills in Microsoft Office (Excel, Word and PowerPoint)
Experience with MS Office 365 a plus

Specialized Skills (required)
• Advanced proficiency in data analysis, data profiling, data extraction, and data mining
• Expert understanding in the design, creation, management, and business use of large datasets
• Intermediate to advanced knowledge of relational & multi-dimensional databases, with emphasis on data warehousing
• Expert knowledge of structured query language (SQL) coding and execution
• Intermediate to advanced knowledge of ETL concepts and processes
• Exposure to advanced analytics concepts such as predictive models and / or machine learning
• Experience designing and developing data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, and linking
• Ability to translate business requirements for data integration needs into artifacts (stories) that can be handed to technical development resources for execution
Strong proficiency in using MS Excel, including formulas and pivot functions.
Specialized Skills (desired)
• AWS Cloud platform : S3, Glue, Redshift, Kinesis / Firehose
• Working knowledge of data governance practices, policies and procedures
• Experience implementing data integrity and data quality processes
• Intermediate understanding of statistical methodologies and techniques utilized for analyzing large datasets
• Experience with one or more business intelligence tools such as Business Objects, Tableau, Qlik, or Power BI
• Experience working with an ETL solution such as Informatica Power Center (or equivalent).
• Experience with Informatica IDQ, EDC, Axon
• Experience with Oracle and SQL Server database management systems
• Working knowledge of Linux O/S scripting
• Experience in Financial Services (automotive
• finance preferable)