Solutions Data Architect

Company: TEKsystems Careers
Location: Lees Summit
Posted on: September 2, 2024

Job Description:

*Description:*
This company is a leader in health services for federal employees and related customers, serving our chosen markets with low-cost offerings and best-in-class customer care, sustained by a nimble and efficient organization.
The Data Architect, Data & Analytics contingent role is to advise, construct and implement the 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.
SKILLS

• 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 Data & Analytics team.
• 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.
• Acts as technical mentor for members of the Data & Analytics team, providing input and feedback to others.
• Responsible for creating and maintaining the catalog of architectural diagrams used by the team.
• 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.
  *Requirements*
  
  • Bachelor's degree in computer information services or a related field.
  • 5 years of experience with enterprise data management, including hybrid and cloud environments.
  • Proficiency with the SQL Server core data engine, SSIS, PowerBI, Visual Studio, MS Office Products and source management tools (e.g., TFS, Git).
  • Proficiency with the following Microsoft Azure resources: Azure Data Lake Storage Gen2, Azure Data Factory, Azure Databricks, Azure SQL Database.
  • 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.
  • Experience working and loading into Data Lake Medallion Architecture.
  • 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 compromise.
  • Requires effective communication and presentation skills. Demonstrates the ability to work and design for multiple projects.
  • Works under minimal supervision with wide latitude for independent judgment.
    *Skills:*
    data management, SSIS, Power BI, Azure Cloud, azure data lake storage gen 2, azure data factory, SQL, Databricks, data warehouse experience, star schemas, tabular models, BI tools, Healthcare payer experience
    *Top Skills Details:*
    data management,SSIS,Power BI,Azure Cloud,azure data lake storage gen 2,azure data factory,SQL,Databricks
    *Additional Skills & Qualifications:*
    Preferred
    
    • 3 years of experience with data warehouse or analytics focused data environments, including star schemas, tabular models and business intelligence tools
    • 3 years of demonstrated experience in the Healthcare industry, with preference for experience with Healthcare Payers.
      *Experience Level:*
      Expert Level
      
      
      
      
      
      About TEKsystems:
      
      We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
      
      The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
      

Keywords: TEKsystems Careers, Lee's Summit , Solutions Data Architect, Other , Lees Summit, Missouri