Senior Solutions/Business Intelligence Architect

3 weeks ago


Ellicott City, United States Omm IT Solutions Full time
Job DescriptionJob DescriptionPlease Note: This is a Hybrid Position with 2 days Onsite and 3 days Remote.

Position Description:


  • Lead development teams and be responsible for the detailed application architecture includes activities of plan, design, development, modification, administration, support, testing, adaption, integration, and implementation of software solutions to all technology initiatives that are of moderate to high complexity levels with integrations.
  • Lead and develop, maintain and support all database related activities.
  • Provide leadership in relational database management systems, including database design, stored procedures, views, triggers, functions, tables, indexes, data import and export processes, schema creation, data dictionaries, master and meta data management and reporting.
  • Set standard and develop SQL programming and SQL objects, including stored procedures, views, triggers, functions, tables, indexes.
  • Execute database solutions, ensuring their stability, reliability, and performance, establishing best practices, and working with other developers in optimizing database and applications.
  • Lead, design, develop, maintain, administer, and support ongoing needs of enterprise business intelligence platform, including the dashboard development, data warehousing data model development, extract transform load(ETL) activates, and reporting and analytical development.
  • Lead, architect, develop, maintain and support the Enterprise reporting needs, including but not limited to Parameterized, Linked, Snapshot, ad hoc, Click Through, Drill Down, Drill Through and Sub reports.
  • Work directly with business owners in the development of various reports and respond to ad hoc reporting requests. Lead and develop data collection and analysis methods and report production.
  • Lead data collection methods, data analysis and report production. Ensure a seamless integration of new and existing systems to eliminate potential problems and maintain data structure and integrity.
  • Provides guidance in the area of user security management, software release management, end user and technical issue troubleshooting, system software upgrade, and dashboard portal design.
  • Develop business requirements and tools for process development, system enhancements and continuous improvement.
  • Works with groups of users to define needs and translates user requirements.
  • Responsible for ensuring application, database meets business requirements by working with stakeholders and translating user requirements into system requirements.
  • Provide viable solutions/recommendations leveraging industry standards & best practices, taking into account current environment, disaster recovery, data integrity, and security.
  • Ensuring feasibility by building prototypes. Ensure architecture is effectively and efficiently designed and successfully implemented.
  • Create high and low-level design documents for systems and applications.
  • Provide training and help to express and unify understanding of architecture.
  • Experience working with Agile Scrum development in a fast paced highly technical environment.
  • The number of hours shall be between 20-40 per individual per week.


RequirementsMinimum Qualifications:

  • 10 Years of experience in Complex Enterprise Application development
  • 10 Years of experience in Microsoft Visual Studio development environment
  • 10 Years of experience in Microsoft .Net development environment
  • 10 Years of experience in application architecture and object-oriented design
  • 10 Years of experience in ASP.NET or VB.Net
  • 5 years of experience in C#.Net with MVC Entity Framework
  • 5 Years of experience in .NET Web services (ASP.NET Web Services, WCF, WPF)
  • 5 years of experience in Scripting language VB Script, Java Script
  • 5 years of experience in markup languages HTML, DHTML, XML
  • 10 Years of experience in Relational Database Management System, must include database design, management of meta data, advanced SQL functions in MS SQL Server
  • 10 Years of experience in Microsoft SQL Server
  • Possess excellent visualization skills and be able to convey customer data in an intuitive and visually compelling way.
  • Experience incorporating best practices around data visualization
  • 5 Years of experience working in Microsoft Business Intelligence Studio
  • 5 Years of experience working with Microsoft SQL Integration Services
  • Experience in creating and managing ETL packages using SSIS
  • 5 Years of experience working with Microsoft SQL Server Reporting Services
  • 5 years of advanced Microsoft SQL Server Reporting Services reporting development
  • 5 Years of experience in usage of Source Control
  • Experience in managing and using Team Foundation Service
  • 5 years of Experience in Cascade style sheets
  • Experience working with bug tracking system
  • Experience working with collaboration software
  • Experience working in K-12 Student Information Application System and / or K-12 Learning Management Application System and / or K-12 Data Warehouse Dashboard and report development and/or ERP System
  • Experience working with an agile, fast paced and highly technical environment
  • Positive references from other K-12 school systems and/or government organizations.

Desired Qualifications:
  • Experience with Edupoint Synergy Student Information System (SIS) or an equivalent SIS system
  • Experience with Instructure Canvas Learning Management System (LMS) or an equivalent LMS system
  • Experience with Power School Unified Insights formerly Hoonuit (DW), a data analytics and data visualization system or an equivalent system
  • Integrations between SIS, LMS and DW systems
  • Experience with Bootstrap
  • Experience with Clever Application Integration
  • Experience working with Atlassian JIRA
  • Experience working with Atlassian Confluence
  • Experience with Tableau BI tools




  • Ellicott City, United States Omm IT Solutions Full time

    Job Description Please Note: This is a Hybrid Position with 2 days Onsite and 3 days Remote.Position Description: Lead development teams and be responsible for the detailed application architecture includes activities of plan, design, development, modification, administration, support, testing, adaption, integration, and implementation of software solutions...


  • Ellicott City, United States Omm IT Solutions Full time

    Job Description Please Note: This is a Hybrid Position with 2 days Onsite and 3 days Remote.Position Description: Lead development teams and be responsible for the detailed application architecture includes activities of plan, design, development, modification, administration, support, testing, adaption, integration, and implementation of software solutions...


  • Ellicott, United States Winning Edge Solutions, LLC Full time

    Sr. Solutions/Business Intelligence Architect in Ellicott City, MD. Key Skills: .Net, C#, MVC, WCF, WPF, VB Script, Java Script, SQL, MS SQL Server, Business Intelligence, ETL/SSIS Description Leading development teams and overseeing detailed application architecture. Managing all aspects of database activities, including design, maintenance, and support....


  • Arizona City, United States RIT Solutions, Inc. Full time

    Intelligent Automation Sr Solution Developer (MSFT Power Platform - MPP - Architect) Our target start date would be 6/4. We have an immediate need for a 6-month contracting position (will renew every six months) for a MSFT Power Platform resource. The details about the expectations are below. We will review and select candidates by 5/17 to interview the...


  • Oklahoma City, Oklahoma, United States OG&E Full time

    Job Description: JOB INFORMATIONJob Title: Solution Architect SeniorJob Code: 124011Pay Grade: 58JOB SUMMARYEqual Opportunity Employer - Minorities, Women, Individuals with DisABILITIES & Veterans Encouraged to apply.Leads IT and business unit members in the design of solutions that combine business process, information, applications and technology to solve...

  • Solutions Architect

    4 weeks ago


    Jersey City, United States Averity Full time

    Job DescriptionJob DescriptionWe are a household name in the high-end / luxury retail space and are looking to grow our internal engineering team rapidly. As a solutions architect on our team, you'll translate our business community's IT needs and future goals into a plan by crafting architecture products, design specifications, statements of work,...


  • Arkansas City, United States JobRialto Full time

    POSITION OVERVIEW : Marketing Cloud Architect - How You'll Help Us: As a Solution Architect, you will have the opportunity to get in on the ground floor of a new division created within one of the largest technology providers in the world. We are building the next generation of digital services company and believe clients are ready for a more nimble, agile...

  • Solution Architect

    3 weeks ago


    Jersey City, United States Tiger Analytics Full time

    Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote global workforce.If you are...

  • Solution Architect

    4 weeks ago


    Jersey City, United States Tiger Analytics Full time

    Job DescriptionJob DescriptionTiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote...

  • Solution Architect

    1 month ago


    Jersey City, United States Tiger Analytics Full time

    Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote global workforce.If you are...


  • Kansas City, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Snowflake Professional Services is the implementation and strategy experts for the Snowflake platform. We engage with customers at all phases of the customer journey to optimize, accelerate, and achieve business outcomes. Our teams of Solutions Architects demonstrate technical leadership everyday by writing...


  • California City, United States Venusgeo Solutions Full time

    C allidus CPQ Business Architect Skills Needed: - SF Bay Area - Coforge / ServiceNow - Description: Our client is currently seeking Callidus CPQ Business Architect Skills Needed: 5-10 years of experience in implementation of Quoting process related to SaaS products using Callidus CPQ. Should know the implementation challenges...

  • Solutions Architect

    1 week ago


    Ohio City, United States Snowflake Computing Full time

    Build the future of data. Join the Snowflake team. Snowflake Professional Services is the implementation and strategy experts for the Snowflake platform. We engage with customers at all phases of the customer journey to optimize, accelerate, and achieve business outcomes. Our teams of Solutions Architects demonstrate technical leadership everyday by writing...

  • Solution Architect

    4 weeks ago


    Jersey City, New Jersey, United States Tiger Analytics Full time

    Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote global workforce. If you are...


  • Texas City, United States Saxon Global Full time

    Title: Director-Business Intelligence Location: 100% Remote Duration: Fulltime ESSENTIAL JOB FUNCTIONS: To perform this job successfully, an individual must be able to satisfactorily perform each essential function listed below. Design, develop, implement, and support complex BI applications of strategic or functional importance including:...


  • Iowa City, United States NR Consulting Full time

    Short Description: The Solutions Architect is responsible for analyzing and documenting the current *** Client (Client) technology systems. Complete Description: The Solutions Architect is responsible for analyzing and documenting the current *** Client (Client) technology systems, including internal components as well as external interfaces for systems...


  • Kansas City, Missouri, United States Burns & McDonnell Full time

    Description1898 & Co., a division of Burns & McDonnell, is seeking an experienced IBM Maximo Solution Architect to join the Enterprise Systems Business Line within the Technology Consulting Practice of 1898 & Co. We seek a qualified Maximo practitioner to provide application, technology, architecture solutions, and services to our clients. ESI Technology...


  • Kansas City, Missouri, United States New York Blood Center Inc Full time

    Overview: At New York Blood Center Enterprises (NYBCe), one of the most comprehensive blood centers in the world, our focus is on cultivating excellence by merging cutting-edge innovation with diligent customer service, groundbreaking research, and comprehensive program and service development. Join us as we work towards meeting and exceeding the growing...


  • New York City, United States Perennial Resources International Full time

    Presales Solution ArchitectCustomer Facing Role Location: New York/New Jersey MetroRole Summary: As a Presales Solution Architect, you will play a pivotal role in driving our sales process from the technical side, working closely with our sales team to understand customer requirements, and designing and presenting solutions that meet these needs. Your...


  • Jersey City, United States BetMGM LLC Full time

    **VP, Analytics & Business Intelligence** - Jersey City, NJ_ **About Us** We are BetMGM. We are revolutionizing sports betting and online gaming in the United States. We are a partnership between two powerhouse organizations—MGM Resorts International and Entain Group. You know our name through our exciting portfolio of brands including BetMGM Sportsbook,...