- +3
- +7
- Germany
About
Please Note
1.This job opportunity is for employment type W2 .
2. Candidates who are willing to apply must hold US work authorization.
Job Title: Data Architect
Job ID: 2022-11301
Job Location: Remote
Job Travel Location(s):
# Positions: 1
Employment Type: W2
Candidate Constraints:
# of Layers:0
Work Eligibility:All Work Authorizations are Permitted – No Visa Transfers
Key Technology:Erwin, SQL, data warehousing, SSIS, SSAS, Agile, Jira, Confluence
Job Responsibilities:
- Participate in requirements gathering sessions to interpret business needs from conceptual models into logical and physical data models.
- Create data models and define the structure and attributes of data elements.
- Develop data warehouse schemas and data marts derived from various internal and external data sources that support reporting requirements for business partners.
- Develop naming standards for all data attributes.
- Assist in the creation of data models and data record layouts to facilitate integration and data exchange with external partners, vendors and regulatory agencies’ applications and systems.
- Create Source to Target Mapping and publish to the Data Engineers to develop the ETLs and Data Pipelines.
- Responsible for documenting databases, processes and design configurations.
Skills and Experience Required:
- Bachelor’s degree in Computer Science, Information Systems, or another four-year degree with significant IS experience or equivalent experience
- 7+ years of experience delivering Data Warehouse solutions
- 5+ years in relational and multi-dimensional data modeling using Erwin as Data Modeling tool
Proficient In:
- Conceptual, Logical and Physical Data Modeling
- Data Modeling Tools: Erwin
- SQL Programming
- Relational Database Concepts
- Data Warehouse Concepts
- Dimensional Data Modeling and Notation
- Microsoft SQL Server
- Microsoft SSIS and SSAS (Tabular Models)
- Data Warehouse Technologies: Snowflake and/or Azure Synapse Analytics/AWS Redshift
- Agile development methods
- Jira & Confluence
INTERPERSONAL AND PROFESSIONAL SKILLS:
- Advanced Analytical Skills – Uses sound and logical judgment to identify and analyze complex, multi-dimensional problems and drive test planning and test execution decisions.
- Teamwork/Collaboration – Develops and leverages collaborative relationships to facilitate the accomplishment of work goals. Collaborates at all levels of the organization. Willingness to help others, as needed, to make the team and each deployment successful.
- Communication – Communicates accurately and effectively in both oral and written form. Practices active listening. Expresses thoughts and ideas with confidence and respects opposing views
- Managing Work – Ability to self-direct and multitask in a fast-paced, ever-changing environment. Identifies task importance; adjusts priorities as appropriate. Prepares and manages schedule to ensure goals are met. Takes prompt action to accomplish objectives.
- Technical/Professional Learning – Keeps up with current developments and trends in the field. Demonstrates strong desire to advance in the field and apply newly acquired knowledge in role.
- Living the Vision and Values – Keeps the company’s vision and values at the forefront of decision-makers
Nice-to-have skills
- SQL
- Data Warehousing
- SSIS
- Agile
- JIRA
- Data Modeling
- Microsoft SQL Server
Work experience
- Data Engineer
- Data Infrastructure
- Database Administrator
Languages
- English