Data Engineer - Support/ SSIS Developer

Pereview Software; Dallas (TX); On-site; USD 100,000 - 168,000; Full time

Job summary

Pereview Software is looking for a SQL/SSIS Developer driven by accuracy and detail to create and manage ETL solutions. Ideal candidates will have experience with Microsoft SQL Server, strong analytical skills, and a passion for problem solving. This role offers an opportunity to work closely with cross-functional teams, ensuring data solutions align with client needs within a growing organization in the commercial real estate sector.

Benefits

Competitive salary

Health, Vision, and Dental benefits

401k with 4% Company match

Qualifications

• 3-5 years experience with Microsoft SQL Server Integration Services (SSIS) required.
• Strong experience with relational database concepts necessary.
• Prior experience with 3rd party interfacing preferred.

Responsibilities

• Troubleshoot and resolve ETL issues ensuring minimal disruption.
• Create comprehensive documentation for recurring issues.
• Engage with clients and internal team members through ticketing systems.

Skills

SQL

SSIS

Data Analysis

Problem Solving

Communication

Education

BS/BA in MIS, Computer Science, Engineering

Tools

Microsoft SSRS

Power BI

Job description

WHO ARE WE?

Pereview Software is the fastest growing provider of asset and portfolio management software to the global commercial real estate industry. To that end, multiple times since our inception, we have been recognized by Inc. 500, Dallas 100 as a fastest growing privately held business in the United States and have also been recognized by the Dallas Business Journal as one of the top places to work.

WHO ARE WE?

Pereview Software is the fastest growing provider of asset and portfolio management software to the global commercial real estate industry. To that end, multiple times since our inception, we have been recognized by Inc. 500, Dallas 100 as a fastest growing privately held business in the United States and have also been recognized by the Dallas Business Journal as one of the top places to work.

Pereview Software is the only life of the asset solution to the commercial investment management industry supporting both debt and equity investments. We serve clients on a global basis from very small investment management managers to some of the largest global firms in the industry.

Would You Describe Yourself As

• Methodical
• Visionary
• Factual Communicator
  
  

If so, please complete the survey upon applying to the role – https://go.cultureindex.com/p/jpWdN1edfuuOn6MKyTV

WHO WE'RE LOOKING FOR?

• Are you a SQL/SSIS developer with a drive for accuracy, quality work, and an innovative mind who want to push through the limits of tech and build something great?
• Do you have the ability to multi-task while exhibiting a sense of urgency by prioritizing appropriately?
• Are you process driven with an appreciation for detail, enjoy working as part of a team or individually with little supervision?
• In this role, being a self-starter in our owner vs. renter culture where everyone is focused on highest and best use of their time and talents toward the strategic goals will bring individual success.
• You should be passionate about your craft, your life, and the impact you can make in a growing organization.
• Developers looking to create and manage ETL solutions that turn data into knowledge.
• You should have a background in data and business analysis. You should be analytical and an excellent communicator.
  
  

If you also have a business acumen and problem-solving aptitude, we’d like to meet you. If this role sounds exciting, apply and let's start the conversation!

Requirements

• 3-5 years experience with Microsoft SQL Server Integration Services (SSIS)
• 3-5 years of experience with Microsoft T-SQL
• Client facing experience
• Strong aptitude to learn and grow
• Prior experience with 3rd party interfacing
• Strong experience with relational database concepts
• Requires analytical, conceptual, and problem-solving skills
• Excellent interpersonal skills
• Excellent written and verbal communication skills
• Strong attention to detail, ensuring accuracy and completeness in all tasks and deliverables
• Knowledge of software development life cycle
• Previous experience in commercial real estate financing preferred
• Previous experience with Microsoft report tools (SSRS, Power BI) is a plus
• BS/BA in MIS, Computer Science, Engineering, or relevant field.
  
  

Responsibilities

• Troubleshoot and resolve ETL issues, such as failed job executions or data transformation errors in SSIS packages, ensuring minimal disruption to business operations.
• Create comprehensive documentation for recurring issues and their resolutions to build and maintain a robust knowledge base for the team.
• Engage with clients and internal team members through ticketing systems, emails, and calls, ensuring technical concepts are clearly conveyed to non-technical stakeholders.
• Investigate and resolve data discrepancies in ETL pipelines by performing root cause analysis and proposing effective solutions.
• Identify and escalate issues beyond personal expertise to the appropriate Data Engineer or Senior Data Engineer, providing a clear summary of the investigation and findings.
• Manage and prioritize incoming support tickets, ensuring efficient ticket handling, timely resolutions, and regular updates to stakeholders.
• Dive deeper into ETL requests and client support issues to align technical solutions with business needs, investigating both the symptoms and underlying causes of data issues.
• Tackle challenges in undefined or evolving situations, such as supporting new ETL pipelines with incomplete documentation. Ensure knowledge gaps are addressed by creating or updating Wiki documentation and knowledge bases.
• Actively follow up on unresolved issues, ensuring clients feel supported and their concerns are addressed promptly and effectively.
• Proactively monitor ETL jobs and logs to identify and resolve potential failures before they impact clients, minimizing downtime and service interruptions.
• Provide technical assistance and cross training to other team members.
• Must be able to perform duties with moderate to low supervision.
  
  

Benefits

WHAT'S IN IT FOR YOU?

• Competitive salary.
• Competitive Health, Vision, and Dental benefits to fit your needs.
• 401k – 4% Company match, 100% vested immediately.
  
  

LOCATION

• Only considering candidates who live in Dallas, Texas (DFW) area.
• *We are not sponsoring F1, H1B or OPT candidates*

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at Pereview Software by 2x

Sign in to set job alerts for “Data Engineer” roles.

Plano, TX $100,000.00-$167,500.00 2 weeks ago

Dallas, TX $128,000.00-$181,000.00 2 months ago

Dallas, TX $120,000.00-$121,000.00 2 days ago

Dallas, TX $120,000.00-$140,000.00 3 weeks ago

Dallas, TX $100,000.00-$130,000.00 1 day ago

Irving, TX $79,851.00-$107,720.00 1 day ago

Dallas, TX $120,000.00-$143,000.00 2 days ago

Irving, TX $80,000.00-$100,000.00 1 week ago

Dallas, TX $120,000.00-$135,000.00 3 days ago

Plano, TX $112,597.33-$152,810.66 1 month ago

Data Engineer III (Full Time) - Sugar Land, East Lawn

Dallas, TX $130,000.00-$150,000.00 2 weeks ago

Plano, TX $144,768.00-$209,109.33 1 month ago

Engineer 2 -Data and Analytics ( MicroStrategy)

Senior Data Engineer (Multiple Positions)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.