The Technical Leader is “Hands-On” manager who is responsible for the design, development and implementation of applications at Amano McGann’s Analytics platform.
Technical Leader will work closely with Enterprise Data and Application Architects, Product Owner and the Center of Innovation/Excellence team to design and implement reporting and analytical solutions.
Duties And Responsibilities
Lead the end to end application design and development of Amano McGann’s Business Intelligence platform.
Mentor and guide application development team on the technical solution that meets business requirements.
Consult with product owners, architects and business owners to determine technical requirements.
Evaluates business processes, workflows, database requirements, user requirements, existing business application functionality and develops project scopes, feasibility studies and technical requirements.
Suggests alternative approaches to meet user requirements.
Responsible for the technical delivery of the software solution that is on-time, on-quality and to the specification.
Present technical vision and architecture to non-technical members of the team.
Knowledge, Skills And Abilities
Demonstrated experience designing, building, and maintaining data warehouses and end-to-end reporting solutions.
Advanced knowledge of Microsoft SQL Server and SQL Server Data Tools,
Experience in Azure cloud Bigdata BI platform is preferred.
Solid understanding of data pipelines, data ingestion, and data delivery into a data warehouse.
Strong Data Modeling skills to include data quality, source systems analysis, business rules validation, source target, mapping design, performance tuning and high-volume data loads.
Sr. level understanding of warehousing architectures including ETL design, staging, transformations, delta/change data capture, star-schemas, cubes, and history loading
Excellent communication skills
Experience working in an agile team environment. Understanding of code promotion, code turnover to operations, version control, and QA procedures. Conduct code walkthroughs, peer reviews, and produce technical documentation
Strong analytical skills and problem-solving ability, including an expertise in soliciting and interpreting customer. business needs and translating them into application and operational requirements.
Demonstrable strong organizational and critical thinking skills with the ability to prioritize and negotiate with stakeholders.
Systems and Standards
Quality Focus - Passionate in helping engineers and 3rd party software teams in building high-quality code and solutions at speed
Pro-active and takes initiatives in deploying and improving existing applications and processes.
Cooperates with senior management and coworkers to ensure that services can be adequately maintained and meets the needs of internal and external customers.
Treats clients and associates with courtesy, respect and dignity.
Interfaces with management and technology support personnel.
Bachelor’s degree in Computer Science, Engineering, or equivalent education; Master’s degree, preferred
Minimum 12 years of experience with software development using Microsoft technologies.
6+ years of leading technical projects.
Demonstrated proficiency with Microsoft Office Suite of products and with Structured Query Language (SQL)
Demonstrated ability to write transact-SQL queries
Demonstrated ability to interact cross-functionally at all levels internally and externally, and ability to develop relationships with vendors, customers and prospects, when appropriate
Ability to quickly learn and effectively leverage operations, enabling technology, processes and other assets
Demonstrated negotiation, facilitation and consensus building skills