Data Architect

Title: Data Architect Duration: 6+ months C2H Location: Kansas City, MO (Will be remote the rest of 2021, but expected to move here and be on-site after.) The Data Architect, Data & Analytics role is to advise, construct and implement the development standards and technical design for the organization's data and analytic solutions. This role will be providing key oversight and direction for the overall architecture, design and implementation to support end user data and analytic needs. This includes responsibility for input on the design of data ingestion, data management, data warehousing, data stores, data extraction and business intelligence tools. The right candidate will have an eye for understanding the needs of the business and champion enterprise data architecture and modeling that will support execution.

• Establishes policies and procedures for data architecture and movement to be implemented by the Analytics Center of Excellence, including policies for standardizing data systems and data software across the enterprise.
• Acts as technical mentor for members of the Analytic Center of Excellence team, providing input and feedback to others.
• Review Business Requirements Documentation, Technical Design Documentation and participate in peer review cycles with technical & non-technical counterparts.
• Establishes and maintains documentation of programs, user guides, policies and procedures, particularly in support of the acceptance of solutions as credible to non-technical users of information.
• Collaborates with Business Data Analysts, Developers and Data Analysts in the development and integration of data, insights and solutions within the purview of the Analytic Center of Excellence.
• Provides oversight, input, design and implementation support for new solution development, including but not limited to new data platforms, data management, primary & secondary storage environments, business intelligence solutions and service-oriented architecture.
• Evaluates existing applications and systems. Recommends improvements or modifications.
• Responsible for creating and maintaining the catalog of architectural diagrams used by the team.
• Support Data Governance efforts, including guidance, stewardship, and frameworks for managing data across the organization and identify opportunities for data reuse, migration, or retirement.
• Recommends training on new technologies to keep the development staff on the cutting edge.
• Encourage and support a self-service architecture to promote a trusted source of distributed data and analytic capabilities and insights, leading the enterprise in its goal to be an insight-driven organization.

• Bachelor's degree in Computer Science, IT, or a related field with at least 3 years of related work experience.
• 5 years of experience with enterprise data management, including hybrid and cloud environments
• Proficiency with the SQL Server core data engine, SSIS, SSRS, PowerBI, Visual Studio, .NET, Powershell (and related scripting languages), MS Office Products and source management tools (e.g., TFS, Git).
• Excellent working knowledge of relational databases such as MS SQL Server or Azure SQL Database including but not limited to indexing best practices and designing and tuning stored procedures.
• Experience observing change management and code promotion through non-production environments.
• Experience in designing systems that use XML/XSLT and/or JSON.
• Experience loading data stores ensuring processes are configurable, resilient, and performant.
• Ability to develop data translation objects and data processing flow using modern tools and adapt to new ones as they become available.
• Proven ability to work independently to coordinate and solve highly complex technical data transformation issues. Ability to effectively communicate with customers to clarify data format requirements and negotiate a compromise.
• Requires effective communication and presentation skills. Demonstrates the ability to work and design for multiple projects.
• Maintains knowledge of current and upcoming technologies. Mentors junior developers conducts code reviews and acts as a resource to others to resolve complex problems.
• Works under minimal supervision with wide latitude for independent judgment.