What are the responsibilities and job description for the Architect - Vantage - IN position at UnitedLex?
About 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.
