Employment Type
Full Time
Skills
Data Architecture design and Deployment, Data Warehousing, Data Modelling, Data Visualization, SQL, MySQL, Tableau
Industry
IT
Job Location
Manchester, NH, USA
Base Salary
$Upto Market Standard
Date posted
March 13, 2020
Valid through
March 20, 2020
PDF Export
Position title
Data Architect
Description
Data Architect will analyze and develop data solutions to support business needs and features of our client's digital properties. The Data Architect will support client's table structures and provide input on best practices and potential efficiencies across the organization. The Data Architect will identify and implement continuous improvement opportunities to refine and improve the data structures. The Data Architect will mentor team members are will work closely with engineering teams and will be responsible for regular peer design and code reviews for any data related enhancements.
- Develop and revise conceptual, logical, and physical data models
- Build and maintain a deep understanding of the data and analytic landscape at Emerson including data sources, data and analytic assets and products, analytic tools and software, and master data
- Determine database structural requirements across departments to align to business operations and our strategic product direction
- Apply expertise and best practices to the development and revision of data architecture standards and conventions
- Serve as the overall company data steward to ensure the proper quality and integrity of data assets.
- Consult on 3rd party data integrations with external partners and vendors
- Create data models that conform to current standards and conventions
- Develop and revise data dictionary definitions, governance practices, and standards;
- Partner with engineering teams to ensure compliance with data security and privacy policies and procedures
Responsibilities
- Understands how data is used to support analytical, commercial and operational reporting
- Works closely with product and commercial teams to obtain requirements for enhancements and/or new analytic assets
- Maps source system data to data warehouse models
- Develops and manages documentation related to data models, flows, and reporting
- Works with teams to integrate data across digital properties, distribution, and financial systems including the management of critical master data
- Develops and tests ETL processes
- Follows standards for technology and technical processes
- Presents technical solutions to stakeholders and end users
Qualifications
- Minimum of 5 years of relevant experience including continuing to innovate data architecture design and deployment, and data modelling
- Bachelor’s degree required, preferably the area of Computer Science, Information Technology/Engineering, Data Science, or related field; masters degree is beneficial.
- Hands-on expertise in data warehousing and architecture, data modelling, master data, big data analytics, real-time analytics, and data visualization, and reporting
- Must possess excellent oral and written communication skills.
- Must possess strong data modeling skills,
- Must possess strong data analysis skills into source systems to profile source system data.
- Must have strong experience with SQL
- Experience with SQL Server platform
- Experience with Tableau reporting tools
- Experience in Healthcare industry is a plus
- A strong foundation and experience in working with complex healthcare data is a plus
- Experience with MySQL a plus, but not required
- Experience in agile development data projects a plus but not required