• Support Financial Reporting domains in the journey by understanding business needs and business goals.
• Understanding the information, and information structures in Financial Reporting domains.
• Work with all stakeholders such as business representatives, other architects, product owners, developers, and testers.
• Obtain a holistic view of business data and business processes.
• Creating the different architectural views for IT solutions.
• Create and update architectural documentation like SAD, Solution assessments, risk analysis, and architectural plans.
• Implement IT strategies into the solutions, and bridge the link between business and IT.
• Provide technical guidance to development and maintenance teams.
• Produce and implement guidelines for the design and development.

Skills: Financial Reporting, Business Analysis, Stakeholder Management, Process Analysis, Architectural Design, Documentation, IT Strategy, Leadership

• Supporting Intelligence and Analytic platforms and the supported applications based on business need and prioritization. 
• Be the highest level technical resource supporting BI and Analytics delivery systems
• Be the primary contact with technology system administrators for system support and design.
• Accountable for the BI and Analytic platform design, implementation and daily management to achieve required service levels.
• Assures the stability, availability and performance of the BI applications, and underlying reports and dashboards.
• Lead and provide technical guidance for the design and implementation of data storage and governance systems 
• Manage custom application development and create delivery model strategies
• Provide scalable services related to high-performance visualization tools and infrastructure design.
• Design and monitor end-user reporting tools and systems, ensuring reports are accurate and up-to-date.
• Collaborate with Business Analysts and end users to ensure that data and reports fulfill business needs.

Skills: Platform Management, Leadership, Collaboration, Platform Design, Performance Assurance, Data Storage, Custom Application, Infrastructure Design

• Partner with system and application database administrators 
• Maintain, support, and enhance the business intelligence data backend
• Responsible for data warehouses and data integration systems
• Document configurations and complex data architectures, ensuring documentation meets current and forecasted needs.
• Maintain technical Vendor relationships and partner with OD leadership, Business Analysts, and OD technology teams 
• Developing and maintaining the OD Analytic roadmap.
• Maintain IT relationships by working with application architects, infrastructure teams, and/or database administrators 
• Work closely with server administration and systems integration teams for hardware and software installation, upgrades and patches.
• Work with Business Analysts and product owners to understand and prioritize application requirements
• Work with UI/UX designers and business intelligence developers 
• Create interfaces that satisfy requirements and adhere to accepted design standards

Skills: Database Management, BI Development, Documentation, Vendor Management, Strategic Planning, Collaboration, Requirement Gathering, Interface Development

• Provide technical acceptance criteria for all application requirements
• Review and accept/approve functional design specifications for new development and major enhancements
• Work with Business Analysts and the testing team to maintain functional test cases and scenarios
• Support the development and maintenance of automated test scripts for load and regression testing
• Review and facilitate remediation of defects resulting from regression and load testing
• Participate in the development process by working with Business Analysts and developers 
• Ensure a thorough understanding of each user story and/or application requirement
• Participate in the change management process by ensuring that documented processes are being followed
• Attend weekly update meetings as defined by the director and/or manager.
• Create and lead application design reviews, and available to interview prospective candidates
• Stay current on emerging technologies

Skills: Functional Design, Test Case Maintenance, Collaboration, Test Script, Defect Remediation, Development Process, User Story, Process Adherence

• Win trust and user adoption and repeat as a template to roll out across the organization.
• Design data warehouse, Kimball-based methodology, to include customer-specific needs.
• Work with SQL SSIS/Azure Data Factory to assist in transformation.
• Azure Automation for data warehouse automation and activities on SQL Azure.
• Work with SQL Azure, SQL Azure DW, and SQL on-premise.
• Work with tabular models within Power BI and also Azure Analysis Services
• Assist in data storytelling and focus on making sure the technical work aligns with the specific questions
• Work with Azure Data Catalog and creation of Source-to-Target mapping
• Updating Azure Data Catalog instances for customers for meta-data tracking/change control/control of semantic layer artifacts.
• Visio diagrams/ERD/pipelines/swim lanes, etc. that help describe and map data.
• Data wrangling concept and ability to perform data discovery 

Skills: Trust Building, Data Warehouse, Azure Automation, SQL Azure, Power BI, Azure Analysis Services, Data Storytelling, Data Discovery

• Lead SQL Server DBA, Architect, and Engineer, and stay current on emerging technologies
• Own the enterprise databases, both transactional and warehousing, in development and production environments
• Leads design, development, testing, and implementation for all new initiatives and modifications to databases, reporting interface, and associated functionality
• Works directly with end-users to understand business needs and design appropriate solutions
• Documents existing and new processes, including business rules, logic, and processes
• Focuses on quality, results, accuracy, performance, and security
• Participate in vendor evaluation and selection process 
• Provide oversight/mentorship for the work of junior team members
• Using business knowledge, analyze data to ensure we are delivering the best results
• Performance tuning, improvement, balancing, usability, automation
• Evaluate and identify new technologies for implementation
• Maintain domain expertise for the functional area, including tracking competitive product developments and best practices

Skills: SQL Server, Database Management, Leadership, Business Analysis, Process Documentation, Quality Assurance, Mentorship, Data Analysis

• Experience working with insurance data with knowledge of Alteryx Analytics
• Understanding of KPIs, contract, claim, and reinsurance data life cycles
• Experience in data warehousing and/or business intelligence unit working with business and IT
• Strong technical knowledge in ETL tools (SQL Server SSIS), Databases (SQL Server 2012)
• Understanding of the relationships of premiums, claims, and reinsurance data
• Strong technical knowledge of OLAP tools (Microsoft SSAS), Reporting Tools (Microsoft SSRS, Power BI)
• The ability to work alone or in conjunction with the DBA
• Prior experience with the implementation of AZURE Data Factory Architecture
• Understanding of SQL DW upgrade and cloud migration strategies
• Experience with the setup and configuration of Power BI (Power Query, Data Management Gateway, SSAS Tabular Connector)

Qualifications: BS in Business Analytics with 7 years of Experience

• Experience with data modeling (normalized and de-normalized data models)
• Experience with Power BI for data modeling and creating visualizations
• High proficiency with Microsoft Stack and Azure technologies (Azure Data Factory, Data Lake, Databricks, SQL Server, Data Warehouse, Analysis Services)
• High Proficiency with Microsoft SQL Server Database Engine (database administration/maintenance), SQL
• Ability to communicate effectively, both in writing and verbally
• Ability to interact effectively with internal and external resources at all organizational levels
• Excellent project management, organization, and follow-up skills
• Strong critical thinking and problem-solving skills
• Must be a team player, and able to work in virtual teams and independently
• Strong financial and business acumen, and ability to speak about technology in the language of business
• Curiosity about business and technology, motivated by a desire to learn

Qualifications: BS in Data Science with 6 years of Experience

• Working experience in Application Development/Leadership, or related field
• Experience in developing roadmaps for the BI Architecture discipline
• Experience working in IT, Data Analysis, Data Visualization, Metadata Management
• Competent in a higher-level coding language such as Python
• Familiarity with Big Data technologies such as Hadoop and Spark
• Expert-level experience in Tableau products and familiarity with SAS solutions
• Experience presenting across all levels of organizational structures
• Strong team and leadership skills with excellent interpersonal skills
• Understanding of operational issues and constraints (e.g. error handling, security)
• Good knowledge of standard methodologies, concepts, best practices, and procedures within a Business Intelligence environment

Qualifications: BS in Information Systems with 5 years of Experience

• Expertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation)
• Experience in logical and physical database design for data warehousing (3NF/Star Schemas) 
• Solid knowledge of SQL writing/tuning on MPP platforms such as Teradata and/or Netezza
• Proven ability to quickly grasp business requirements and translate them into optimized solution blueprints
• Strong problem-solving, collaboration and communication skills 
• Passion for leveraging data to improve business outcomes
• Experience in developing and implementing complex data warehouse and BI solutions
• Familiarity with predictive modeling tools like SAS
• Experience in cable or another telecommunications service provider
• Familiarity with Agile development methodologies such as Scrum, Kanban, and SAFE

Qualifications: BS with a focus in Information Technology with 7 years of Experience

• Experience in data modeling, data architecture, reference and master data management
• Working experience as a MicroStrategy Administrator
• Must have strong SQL and analysis skills
• Excellent written and spoken communication skills 
• The ability to engage with teams who may be remote
• Proficiency in Technology including MicroStrategy BI Tools, Linux, Azure
• Experience in computer science, engineering or management information systems
• Understanding of Scrum Development methodologies and experience as a member of Scrum teams
• Strong Technology such as SQL Server, Hadoop, NoSQL, and other BI platforms (PowerBI, Thoughtspot, etc.)
• Solid understanding of SQL Server DB, SSIS, SSAS Tabular Cube, .Net
• Excellent understanding of Power Shell, DAX, and Power BI
• Knowledge about SQL Query, T-SQL, and SSIS Package Optimization.

Qualifications: BS in Computer Science with 4 years of Experience

• Experience in designing, and developing ETL Programs, SSAS Cube
• Working experience in creating technical design documentation for ETL Programs.
• Experience as a technical leader in the application of industry-accepted Software Development Life Cycle
• The capability to understand high-level architectural concepts and create product technology roadmaps.
• Advanced Experience working with Microsoft Business Intelligence tools, specifically SSIS
• Experience solutions and development of ETL, OLAP Cube, and working w/APIs
• Knowledge of C#/VB.NET, DAX, and Power Shell scripting 
• Flexible during times of change with the ability to navigate and resolve ambiguity.
• Excellent organizational skills and the ability to multi-task.
• Have attention to detail with excellent interpersonal skills.
• Excellent written and verbal communication skills.
• Ability to train and guide others, and work well in a dynamic team environment.

Qualifications: BS in Statistics with 6 years of Experience