About the job
Job DescriptionAbout Us
iRunway (Erstwhile UnitedLex) is a data and professional services company delivering outcomes that create value and competitive advantage for legal and the business. Our business is anchored by a passion for innovation brought to life by a global community of diverse individuals determined to deliver on the promise of data mastery, legal acumen, and human ingenuity.
Requirements & Competencies
Required Experience
Minimum total of 8 years in information technology
Minimum 4 years hands-on experience in BI/DW design, development, and implementation
Project Delivery Competence
Strong ability to design and deliver enterprise data warehouse and business intelligence platforms
Ability to collaborate with technical and non-technical individuals to solve complex business problems
Ability to understand needs within the context of a specific organization and identify appropriate technology solutions to maximize ROI with the solutions that are implemented
Technology Skills & Experience
In-depth understanding of a wide range of database systems and architecture practices
In-depth experience with designing, administering, and maintaining Microsoft SQL Server and Databases
Experience with architecting star, snowflake galaxy schemas for data modeling
Experience in analysis and selection of BI platforms based on the data topography and needs of an organization
Experience with a major ETL tool, preferably Azure Data Factory
Experience with OLAP model and OLTP database models
Experience with Azure Lakehouse Architecture
Experience with Azure Data Bricks/Azure Synapse / Azure Analysis Services / (DW)/ADLS preferred
Experience with self-service BI tools, preferably PowerBI and the DAX language
Experience with cloud and hybrid data topographies
Experience working with various third-party data sources (MS Dynamics AX, HR/ERP systems, Salesforce, etc.) and connections to these through APIs as well as direct-to-DB and flat files
Experience maintaining data quality and integrity in a complex and ever-changing data environment
Experience maintaining source code in Git and managing a CI/CD pipeline, preferably with Azure DevOps
Experience with Python and R programming languages is a plus
Firm understanding of web applications and/or other distributed application architectures
Exposure to unstructured/semi-structured data systems (NoSQL) is preferred
General/Soft Skills
Strong organization skills and high attention to detail
Ability to multi-task with good decision-making, analytical and problem-solving abilities
Ability to learn the intricacies of a new industry and move through new topics at a rapid pace
Excellent oral, written, presentation and interpersonal communications skills; Ability to effectively exercise tact, discretion, judgment and diplomacy when interacting and/or negotiating with internal and external customers
Ability to present and explain technical information in a way that establishes rapport, persuades others, and gains understanding
Ability and willingness to accept responsibility, willingness to challenge established practices and draw relevant conclusions, including the persistence and willingness to take calculated risk, to stimulate, market and sell new ideas within the organization.
Education
Bachelor’s degree (preferably in Computer Science, MIS, or a related field) OR equivalent work experience required
Responsibilities
Analyze BI needs, recommend BI solutions and strategy, design and implement an enterprise BI platform
Map out enterprise data systems/objects and define/design required ETL systems/processes
Document and maintain architectural design, technical configuration and mapping
Document and maintain best practices, standards, and processes for managing the BI/DW systems and services
Recommend on-going improvements to business and technology processes related to BI needs and solutioning
Lead, provide technical guidance, and serve as a mentor to other team members
Participate in technology leadership meetings to provide feedback and recommendations to the other leaders
UnitedLex is committed to preserving the confidentiality, integrity, and availability of all the physical and
electronic information assets throughout the organization. Consistent with the UnitedLex ISMS policy
and the ISO 27001 standard, every employee is responsible for complying with UnitedLex information
security policies and reporting all security concerns, weaknesses, and breaches.