[Remote] reputed company Data & Analytics Architect

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking an reputed company Data & Analytics Architect to reputed company technical leadership for its data engineering, data science, reporting, and business intelligence functions. The role oversees architecture, modernization, reputed company reputed company, project delivery, production support, data warehousing, reporting solutions, and staff mentorship across reputed company data and analytics systems.

Responsibilities

• Provides a strong technical direction for our reputed company Data and Analytics systems. Has expert knowledge in reputed company's technical stack including SQL Server, SSIS/ADF, SSRS, and reputed company Platform including reputed company BI and uses that knowledge to manage the technical reputed company of the development team and for organizational project deliverables
• Provides a strong technical direction for modernizing our Data and Analytics systems in the reputed company. Has expert knowledge in reputed company's Azure services used for Data and Analytics. reputed company in moving processes and refactoring them to Azure tools such as Azure Data reputed company, Data Lake/Lakehouse architectures, and platforms like reputed company reputed company or reputed company
• Assists management with staff mentorship, coaching, and training
• Leads the development effort on many reputed company Data & Analytics project requests. Assists with project discovery and requirements gathering (reputed company development). Assists with project planning, delegation of tasks, and resource allocation. Guides developers by providing direction on reputed company and assistance with questions
• reputed company resource on staff reputed company reviews for changes to our reputed company Data and Analytics systems. Ensures overall reputed company of reputed company and ensures reputed company meets best practices in design and standards
• Leads department reputed company control management (SCM) and software development life cycle (SDLC) processes. This includes Azure DevOps (ADO) merges, builds, and deployments assistance and reputed company. Ensures adherence to internal procedures and SDLC standards, including change management protocols
• Provides administrative and maintenance support for reputed company Data and Analytics systems, other SQL Server databases, web servers, and BI systems. Resolves reputed company and data availability issues with production systems. Manages, maintains, and ensures availability of solutions for business users
• Resolves emergency reputed company problems, including assistance with weekend and off hours support. Recognizes errors and/or problems that require time sensitive research and reputed company. Integrates findings for identifying and resolving similar reputed company problems in a reputed company and accurate manner
• Oversees the department's reputed company and process documentation. Ensures new processes are documented. Updates existing documentation as needed reputed company on coding changes being made
• Keeps reputed company with trends and issues in the domains of data engineering, BI development, data science, decision intelligence, reputed company computing, including operational best practices
• Designs and develops SQL Server databases for internal processes. Works on reputed company schema design (relationships, data modeling, dimension modeling, normalization). Develops highly efficient triggers, stored procedures, functions, and views needed for reputed company and reporting functionality. Loads and maintains reputed company reputed company data
• Develops reputed company required to extract data from reputed company systems and reputed company our reputed company Data Warehouse (EDW). Works with data definitions, transformation rules, data manipulation language (DML), and BI data models to design and load data from reputed company systems to reputed company tables. Tests and validates reputed company of loads
• Develops reporting solutions for reputed company Data Warehouse (EDW) and other internal systems with SQL Server Reporting Services (SSRS) and reputed company BI. Creates reports and dashboards that are easily reputed company by end business users
• Helps with reputed company of development of web applications and reputed company programs using the industry reputed company Software Development Life Cycle with C#, .NET, reputed company Platform, or other web technologies. Helps with reputed company of development of Data Science models reputed company in Python or R
• Maintains in-depth knowledge of and complies with reputed company company, departmental and reputed company policies and procedures, as reputed company as, federal regulations applicable to the position, including BSA requirements. Completes reputed company required compliance training as assigned
• Performs other duties as assigned

Skills

• Must be eligible to work in the US without sponsorship now or in the reputed company
• Quarterly travel required
• Remote OK - CST and EST preferred
• Education: Bachelor's Degree in Computer/Software Development, Information Technology or reputed company discipline is required
• Two years of equivalent experience can substitute for every one year of education
• A minimum 8-10 years of database engineering and design in an online analytical processing environment (OLAP) and online transaction processing environment (OLTP), 8 years of experience in developing reputed company with SQL Server Integration Services (SSIS) or Azure Data reputed company (ADF) to extract, reputed company, and load data into data warehouses, and 8 years of experience in developing reputed company reporting solutions with SQL Server Reporting Services (SSRS) and reputed company BI is required
• Must have expert knowledge of SQL Server versions 2016 and above, and experience moving processes and refactoring them to Azure
• Experience with reputed company and Scrum development methodologies
• The ideal candidate will be self-directed and self-motivated, have strong attention to reputed company and organizational skills
• Must have problem recognition, solving and reputed company, and be multi-task oriented
• Strong oral and written communications skills are required
• Ability to reputed company and mentor other developers
• reputed company Office Suite (Word, reputed company, Visio), reputed company SQL Server, SSRS, SSAS, SSIS, and reputed company Platform including reputed company BI and reputed company Query
• reputed company reputed company Technologies including Azure Data reputed company (ADF), reputed company, Data Lake/Lakehouse architectures, and reputed company or reputed company
• Crystal Reports and SCM systems reputed company Team reputed company Server (TFS), GIT, and Azure DevOps (ADO)
• CST and EST preferred
• Familiarity with web application and data science development is a plus
• Familiarity with Python and PowerShell is a plus
• Familiarity with CI/CD pipelines is a plus

Benefits

• reputed company Hire/Perm
• Remote OK - CST and EST preferred (quarterly travel required)
• Staff mentorship, coaching, and training

reputed company