The Lead Business Intelligence Developer will work independently and provide thought leadership around analytics, data governance, visualizations, designing and implementing algorithms using artificial intelligence/machine learning. You will constantly peruse the technology landscape to ensure that the Bank’s analytical technologies are suitable for purpose and efficiently deployed. You may also lead BI technology initiatives, model new datasets and develop new analytics tools for our stakeholders.
Ensure compliance with company policies, procedures, and Federal/State regulations
Navigate Microsoft Office Software, computer applications, and software specific to the Information Systems department in order to maximized technology tools and gain efficiency
Design simple integrations and implements data integration solutions designed by an integration architect ensuring that solution meets defined requirements using C#, SQL or other equivalent programming languages
Ensure that the solution follows data integration best practices
Determine how to import and transform the data to fit approved data architectures
Work with DBAs and data administrators to determine how to meet service level agreements
Design simple rules and implement all rules for cleansing the data in adherence with data quality policies
Help with the selection of data integration tools and seeks ways to improve services through the use of tools.
Follow PMO governance processes to initiate, execute, and close a project on behalf of a customer/sponsor
Maintain awareness of current technology stacks and recommends developments that can have positive impact on the enterprise to management
Design and develop ETL solutions using SQL Server Integration Services (SSIS), SQL Server and other languages/tools
Write technical specifications for data integrations, applications, systems and solutions
Create and maintain architecture diagrams, design diagrams and data flow diagrams using Microsoft Visio or other equivalent tools
Work with internal customers to assess business needs and work with a team to design solutions
Support and provide maintenance programming for applications using approved technologies
Maintain expertise in current technology stacks and best practices to recommend changes that can have positive impact on the enterprise
Develop, implement, and participate in all phases of the software development life cycle (SDLC)
Lead requirements gathering, analysis and application design for medium and large projects
Establish best practice to embed information security and regulatory requirements in SDLC
Works with team to complete project requests
Troubleshoot and resolve daily issues with the perspective of minimizing incidents and developing supporting documentation that may be used by Tier 1 support teams
Accept mentorship from senior developers and may mentor Application Developer I and II
Develop and execute plans to install new software and custom changes following Change Management disciplines
Bachelor's Degree in Computer Science, Information Technology
Engineering with a concentration in data management, analytics, programming or related
Knowledge of object oriented programming using C#, Java or similar contemporary programming languages
Certifications in: Microsoft Certified Solutions Developer (MCSD), Microsoft Certified Solutions Expert (MCSE), Microsoft Certified Solutions Architect (MCSA)
Understanding of relational data model
BI/Analytics development experience (professional or classwork) using Microsoft technology stack (e.g. .NET, C#, SQL Server) or equivalent technologies and toolset e.g. Java, Python, Oracle, MySQL, etc.
Solid knowledge of Microsoft SQL Server, SSIS, SSAS (tabular model) and equivalent technologies available from other vendors
Write SQL statements for relational database management systems like SQL Server, Oracle, or MySQL and using contemporary NOSQL databases like Mongo or Cassandra
Ability to work with large datasets in building pipelines, pipeline architectures and integrated datasets using traditional data integration technologies using APIs, SQL Server SSIS, etc.
Ability to work with application development and SQL on Hadoop
Skill in working with and optimizing existing applications and helping to move them in production
Skill in working with source code repositories like Microsoft Team Foundation Services (TFS), GitHub, SVN or other equivalent tools Experienced in branching, merging, release management, versioning, etc;
Knowledge of Microsoft Azure, Amazon Web Services or any other cloud ecosystem
Skill in incorporating best practices on information security into development efforts;
Ability to monitor, support, and trouble-shoot applications/systems running on Windows servers and Microsoft SQL servers
Knowledge of message queuing technologies such as Kafka, Azure Service Bus, and stream data integration technologies or stream analytics technologies such as Apache Kafka KSQL, Spark Streaming and others
Create ETL solutions using SQL Server Integration Services (SSIS) or other equivalent technologies
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.
OpenArc is a technology consulting firm providing industry-leading technical talent placement, software development, and technology strategy services to clients nationwide. Through a unique blending of people and software, OpenArc has a business practice that delivers amazing enterprise, mobile and consumer-facing apps and the best talent for contract, contract-to-hire and direct placements for clients and partners alike.
Staffed with the most-trusted recruiting experts, elite software developers, UI/UX designers and market experts, our team provides clients with the best resources, the right techniques and world-class support resulting in powerful measurable success.